论坛首页 入门技术论坛

ORA-01045: user lacks CREATE SESSION privilege; logon denied

浏览 13950 次
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
作者 正文
   发表时间:2009-08-21   最后修改:2009-08-21


[oracle@bogon ~]$ sqlplus  / as  sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 21 03:07:12 2009

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  301989888 bytes
Fixed Size                  1219088 bytes
Variable Size             104859120 bytes
Database Buffers          192937984 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
SQL> create user MOMNPUP identified by MOMNPUP
  2  ;

User created.

SQL> grant RESOURCE to MOMNPUP;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@bogon ~]$ sqlplus MOMNPUP/MOMNPUP

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 21 03:10:09 2009

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

ERROR:
ORA-01045: user MOMNPUP lacks CREATE SESSION privilege; logon denied


Enter user-name: system
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>grant create session,resource to MOMNPUP;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@bogon ~]$ sqlplus  MOMNPUP/MOMNPUP

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 21 03:14:47 2009

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>
论坛首页 入门技术版

跳转论坛:
Global site tag (gtag.js) - Google Analytics