Oracle - 2

上一篇 / 下一篇 2009-06-29 15:18:19 / 个人分类：Oracle

SQL Plus:

1. show user - show current connection user

2. desc dba_users - the description of table dba_users which record all users of database.

3. Set lines = 200

4. Select username, access_status from dba_users; - select

5. alter user scott account unlock; - unlock user

6. alter user scott account identified by tigger; - enable user

7. conn scott tigger; - build connection

TAG: