1. The super Administrator is logged in Oracle:sqlplus/as sysdba 2. Displays the current connected user sql> show User3. Create a new user and authorize sql> to create a user a identified by A; Built under system table space) Pl/sql> grant Connect,resource to a;4. query table Structure sql> desc a5. Unlock method: After you log in with system, execute the following command: & Nbsp; sql> alter user Scott account unlock; users have changed. This completes the unlock operation. Next, you can also reset the password to the Scott user. change Scott's login password: sql> alter user Scott identified by Tiger; the user has changed. you're done, now you can log in with Scott and Tiger! sql> conn scott/tiger is connected. Learning Oracle Database experience: 1. Enter Sqlplus in DOS command to open oracle bring in SQL Plus and login prompt, while input sqlplus/nolog open SQL Plus does not appear login prompt; & Nbsp;2. Enter Conn in SQL Plus to connect to the database in one of the formats: sql> conn username/password such as: Conn scott/tiger & nbSp;3. Code to lock and unlock users in Oracle: sql> alter user username account lock; (locking) SQL> alter user username account unlock; (unlock)
Oracle User Actions
