Use the DROP USER statement to remove a database user and optionally remove the user's objects.In an Oracle Automatic Storage Management (Oracle ASM) cluster, a user authenticated AS SYSASM can use this clause to remove a user from the password file that is local to the Oracle ASM instance of the current node.When you drop a user, Oracle Database also purges all of that user's schema objects from the recycle bin. Dropping a Database User: Example If user Sidney's schema contains no objects, then you can drop sidney by issuing the statement:DROP USER sidney; If Sidney's schema contains objects, then you must use the CASCADE clause to drop sidney and the objects:DROP USER sidney CASCADE; http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/statements_9008.htm#SQLRF01811------------------------------------------------------------------------------ Blog: http://blog.csdn.net/tianlesoftware 网上资源: http://tianlesoftware.download.csdn.net 相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 群:62697716(满); DBA2 群:62697977 DBA3 群:63306533; 聊天 群:40132017
Dropping a Database User: Example
If user Sidney's schema contains no objects, then you can drop sidney by issuing the statement:DROP USER sidney;
If Sidney's schema contains objects, then you must use the CASCADE clause to drop sidney and the objects:DROP USER sidney CASCADE;
http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/statements_9008.htm#SQLRF01811------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
DBA3 群:63306533; 聊天 群:40132017
SQL>drop user <用户名> cascade;