刪除表空間，刪除用戶，管理用戶

刪除表空間，刪除用戶

SYS@hditest >alter user system identified by system;

User altered.

SYS@hditest >DROP TABLESPACE TBS_WMS INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

SYS@hditest >DROP USER ewm  CASCADE  ;

User dropped.

管理用戶

1.修改用户密码
SQL>alter user username identified by password;
2.锁帐号
SQL>alter user username account lock;
3.解帐号
SQL> alter user username account unlock;
4.设置密码过期
SQL> alter user username password expire;
5.锁定帐号并使用密码过期
SQL> alter user username account lock password expire;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15187685/viewspace-741402/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15187685/viewspace-741402/