Database Security Products (MOSC)

MOSC Banner

SYS WITHOUT ADMIN OPTION

edited Jul 13, 2010 8:30PM in Database Security Products (MOSC) 2 commentsAnswered
Why Does the user sys have ADMIN OPTION=NO?

select * from dba_sys_privs where privilege LIKE '%SYNONY%' AND GRANTEE ='SYS';

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
SYS                            CREATE PUBLIC SYNONYM               NO
SYS                            CREATE SYNONYM                           NO
SYS                            DROP PUBLIC SYNONYM                   NO
SYS                            DROP ANY SYNONYM                        NO
SYS                            CREATE ANY SYNONYM                     NO


Any ideas?
 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center