This discussion is archived
9 Replies Latest reply: Dec 10, 2012 6:36 AM by marlborocat RSS

why all users can not login to database?

marlborocat Newbie
Currently Being Moderated
I have to grant DBA to the user??


SQL> create user test_1 identified by test123;

User created.

SQL> grant create session to test_1;

Grant succeeded.

SQL> exit

:->sqlplus test_1/test123

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Dec 7 15:24:06 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-30511: invalid DDL operation in system triggers
ORA-06512: at "SYS.LOAD_SESSION_MONITOR", line 13
ORA-06512: at line 2


Enter user-name: ^C
(hqw0cdt1sora02.dev.pbgc.gov-oracle-pmtgen1) /orabin/rdbms/1020g/dbs
:->sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Dec 7 15:24:08 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


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

SQL> grant dba to test_1
2 ;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
(hqw0cdt1sora02.dev.pbgc.gov-oracle-pmtgen1) /orabin/rdbms/1020g/dbs
:->sqlplus test_1/test123

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Dec 7 15:24:17 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


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

SQL>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points