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

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?
>
> - D

probably every release of oracle comes with a bucketload of new "... any ..." style privileges as they invent things like types, objects, directories, libraries etc....Chuck them into a role (eg DBA) and both SYS and SYSTEM are sorted out in one hit...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."