2 Day DBA > Managing Users and Security > Logging In as an Administrator
Logging In as an Administrator |
Previous |
Next |
There are three ways to log in to Oracle Database Express Edition (Oracle Database XE) to perform administrative tasks:
Log in as user SYSTEM
Log in as a user who has been granted the DBA
role
Log in and connect to the database as SYSDBA
Table: Database Administrator Login Methods provides information about each of these login methods.
Database Administrator Login Methods
Login Method | Permitted In | Notes | See |
---|---|---|---|
Log in to the database as user |
The Oracle Database XE graphical user interface and SQL Command Line |
For routine administrative tasks like managing memory and managing users. You must supply the password for the |
|
Log in to the database as a user who has been granted the |
The Oracle Database XE graphical user interface and SQL Command Line |
For routine administrative tasks like managing users. An administrator must first grant the |
"Logging In as a User with the DBA Role" |
Log in and connect to the database as |
SQL Command Line |
For high-level administrative tasks like starting up and shutting down the database, and changing the |
"Logging In and Connecting to the Database as SYSDBA" |