Oracle Database Login

Administrator Login Statement

Account must be added as SYSDBA for example: SYS as SYSDBA

Show current user show users;

Shows which users of the system have SELECT * from All_users;

Creates a new user and authorizes the Create user user_name identified by User_password; (default is built under system table space)

Grant Connect,resource to A; (authorization)

Connect to a new user conn User_name/user_password

Unlock the ALTER user Scott account UNLOCK on the ordinary accounts;

Modify the password alter USER SOCTT identified by Tiger;

Queries all objects under the current user SELECT * from tab;

Oracle Database Login