oracle 账号管理

  1、用户创建

SQL> create user web_hgz identified by admin123;

User created.

SQL> col username format a10;  --col为column缩写，format a10指定格式宽度为10个字符

SQL> col account_status format a15;

SQL> select username, account_status, lock_date, expiry_date from dba_users where username = ‘web_hgz‘;

USERNAME   ACCOUNT_STATUS  LOCK_DATE           EXPIRY_DATE

---------- --------------- ------------------- -------------------

web_hgz         OPEN

  2、 解除用户锁定

SQL> alter user hr account unlock;

User altered.

SQL> select a.username, a.account_status, a.lock_date from dba_users a where a.username = ‘HR‘;

USERNAME   ACCOUNT_STATUS                    LOCK_DATE

---------- -------------------------------- -------------------

HR         OPEN

oracle 账号管理

原文：http://2841314881.blog.51cto.com/10852398/1719112