Oracle 11g新特性之用户重命名 - 数据库编程

L> alter user scott rename to tiger identified by scott;

User altered.

SQL>

SQL>
?
SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> startup

ORACLE instance started.

Total System Global Area 941600768 bytes

Fixed Size 1348860 bytes

Variable Size 629148420 bytes

Database Buffers 306184192 bytes

Redo Buffers 4919296 bytes

Database mounted.

Database opened.

SQL>

6.确认结果

原来的scott用户已经被重命名为tiger用户，现在，我们验证一下tiger用户是否能够正常登陆，原来的scott用户是否还存在。

SQL> conn scott/tiger
?
ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

SQL>

SQL> conn tiger/scott

Connected.

SQL>

SQL> select * from cat;

TABLE_NAME TABLE_TYPE

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

BONUS TABLE

DEPT TABLE

EMP TABLE

HOEGH TABLE

SALGRADE TABLE

SQL>?

Oracle 11g新特性之用户重命名(二)