Skip to content

Latest commit

 

History

History
57 lines (43 loc) · 1.47 KB

oracle.md

File metadata and controls

57 lines (43 loc) · 1.47 KB

Oracle

Oracle Database is a powerful, enterprise-grade relational database management system (RDBMS) developed by Oracle Corporation. Known for its scalability, reliability, and advanced features, Oracle supports a wide range of applications, from small businesses to large enterprises. It offers high availability, security, and comprehensive tools for data management, making it a popular choice for mission-critical applications.

Index

  • Default
    • Port : 1521
    • User : sys sysdba
    • Database : ORCL XE
  • Example

Example

User

  • Create
ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
CREATE USER "DEBUG" IDENTIFIED BY "ABcd!@34" DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE "DEFAULT" ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "DEBUG";
GRANT "CONNECT" TO "DEBUG";
GRANT DBA TO "DEBUG";
GRANT "RESOURCE" TO "DEBUG";
GRANT CREATE SESSION,CREATE TABLE,CREATE VIEW TO DEBUG;
GRANT SELECT ON SYS.USER$ TO DEBUG;
GRANT SELECT ON SYS.OBJ$ TO DEBUG;
  • Delete
ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
REVOKE DBA FROM DEBUG;
DROP USER DEBUG CASCADE;
  • Password
ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
ALTER USER "DEBUG" IDENTIFIED BY "ABcd!@34";