Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> License maximum (46) exceeded, DBA logon allowed
Dear all,
A non-DBA user is allowed system login even after max. sessions exceeded on Oracle 7.3.4 "(License maximum (46) exceeded, DBA logon allowed)". Although that user is not a DBA and has following privileges assigned. What may be causing this behavour?
How does Oracle identifies a user as DBA?
I will be grateful for your help.
Regards
" 1* select * from ROLE_sys_privs
EXP_FULL_DATABASE BACKUP ANY TABLE
NO
EXP_FULL_DATABASE EXECUTE ANY PROCEDURE
NO
EXP_FULL_DATABASE SELECT ANY TABLE
NO
SUPROLE_1 ALTER ANY INDEX NO SUPROLE_1 ALTER ANY SNAPSHOT NO SUPROLE_1 ALTER ANY TABLE NO SUPROLE_1 ALTER SESSION NO SUPROLE_1 ANALYZE ANY NO SUPROLE_1 BACKUP ANY TABLE NO SUPROLE_1 COMMENT ANY TABLE NO SUPROLE_1 CREATE ANY INDEX NO SUPROLE_1 CREATE ANY PROCEDURE NO SUPROLE_1 CREATE ANY SEQUENCE NO SUPROLE_1 CREATE ANY SNAPSHOT NO SUPROLE_1 CREATE ANY SYNONYM NO SUPROLE_1 CREATE ANY TABLE NO SUPROLE_1 CREATE ANY TRIGGER NO SUPROLE_1 CREATE ANY VIEW NO SUPROLE_1 CREATE PUBLIC SYNONYM NO SUPROLE_1 CREATE SESSION NO SUPROLE_1 DELETE ANY TABLE NO SUPROLE_1 DROP ANY INDEX NO SUPROLE_1 DROP ANY SNAPSHOT NO SUPROLE_1 EXECUTE ANY PROCEDURE NO SUPROLE_1 INSERT ANY TABLE NO SUPROLE_1 LOCK ANY TABLE NO SUPROLE_1 SELECT ANY SEQUENCE NO SUPROLE_1 SELECT ANY TABLE NO SUPROLE_1 UPDATE ANY TABLENO
29 rows selected." Received on Tue Jan 15 2002 - 02:07:56 CST