oracle grant 語句的GRANT privilige TO user IDENTIFIED BY password 語法的再次試驗-user已經存在但是賦予不同密碼

oracle grant 語句的GRANT privilige TO user IDENTIFIED BY password 語法
-user已經存在但是賦予不同密碼


C:Documents and SettingsAdministrator>sqlplus scott/aaaaaa@lei

SQL*Plus: Release 11.1.0.6.0 - Production on 星期六 10月 8 22:01:59 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.


連線到:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
從 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 斷
開

C:Documents and SettingsAdministrator>sqlplus system/aaaaaa@lei

SQL*Plus: Release 11.1.0.6.0 - Production on 星期六 10月 8 22:04:48 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.


連線到:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER
2 ;

授權成功。

SQL> exit
從 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 斷
開

C:Documents and SettingsAdministrator>sqlplus scott/aaaaaa@lei

SQL*Plus: Release 11.1.0.6.0 - Production on 星期六 10月 8 22:05:05 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


請輸入使用者名稱:

試驗結論：

GRANT privilige TO user IDENTIFIED BY password 語法 當此user使用者存在時，會更新此使用者的密碼，這算一個修改密碼的方法了。呵呵。。

[@more@]