Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> License maximum (46) exceeded, DBA logon allowed

License maximum (46) exceeded, DBA logon allowed

From: Faisal Qasim <faisal_qasim_at_my-deja.com>
Date: 15 Jan 2002 00:07:56 -0800
Message-ID: <7d83d0a4.0201150007.72b299f8@posting.google.com>


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 TABLE                       
 NO

29 rows selected." Received on Tue Jan 15 2002 - 02:07:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US