Re: sys gets a lot of its privs through roles?

From: Joe Kazimierczyk <joseph.kazimierczyk_at_bms.com>
Date: Fri, 20 Jul 2001 07:22:29 -0400
Message-ID: <3B581475.466254C9@bms.com>

Doug C wrote:
>
> It appears to me that sys does not have an extremely large amount of directly
> granted system privileges. Sys can grant itself anything of course, but quite a
> few ditties come through roles. Just out of curiousity.. why is this? Why
> doesn't it just have the whole enchilada?

I'm just guessing, but since SYS owns the oracle dictionary tables and stored procedures, it just doesn't need system privileges. It can do almost anything to the database since it's the owner - it's other users who need privileges to do the same things. I see that it does have some of the 'ANY' privs so that sys can do things to objects owned by other users which makes sense. Received on Fri Jul 20 2001 - 06:22:29 CDT