更新时间:2022-09-01 11:11:06
SQL> select * from v$version ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> drop user test1;
User dropped.
SQL> drop user test1;
drop user test1
*
ERROR at line 1:
ORA-01918: user 'TEST1' does not exist
SQL> grant dba to test1 ;
grant dba to test1
*
ERROR at line 1:
ORA-01917: user or role 'TEST1' does not exist
SQL> grant dba to test1 identified by xxx;
Grant succeeded.
--ok! test1用户建立好.
SQL> connect test1/xxx
Connected.
SQL> show user
USER is "TEST1"