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用户存在时,会更新此用户的密码,这算一个修改密码的方法了。呵呵。。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/161195/viewspace-1055514/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/161195/viewspace-1055514/