2010-03-13 09:19 ORA-01045: user lacks CREATE SESSION privilege; logon denied

 

C:\Documents and Settings\Administrator>exp xhh/xhh123 file=c:\xhh.dmp full=y

Export: Release 11.2.0.1.0 - Production on 星期一 10月 15 10:52:22 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

EXP-00056: 遇到 ORACLE 错误 1045
ORA-01045: user XHH lacks CREATE SESSION privilege; logon denied
用户名:
口令:

 

当我们执行exp时，oracle提示用户缺少create session权限的错误信息：

使用grant 授予用户create session 和resource权限

 

SQL> grant create session,resource to xhh;

授权成功。

SQL>

 

授权后，再次执行exp成功：

C:\Documents and Settings\Administrator>exp xhh/xhh123 file=c:\xhh.dmp full=y

Export: Release 11.2.0.1.0 - Production on 星期一 10月 15 10:53:54 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
EXP-00023: 必须是 DBA 才能执行完整数据库或表空间导出操作
(2)U(用户), 或 (3)T(表): (2)U >

 

 

 

---------The End

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8541492/viewspace-746421/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8541492/viewspace-746421/