Re: Problem granting permissions

On Tue, 10 Feb 2004 21:28:58 GMT, in comp.databases.oracle.server, Brian Peasland <dba_at_remove_spam.peasland.com> scribbled:

>USER_ROLE_PRIVS is a view itself, not a table.

Indeed, I had looked at that. Thanks for the reminder.

>The underlying "tables"
>to USER_ROLE_PRIVS are SYS.USER$ and SYS.X$KZDOS. I have no idea what
>ROLE_ROLE_PRIVS is.

It is also a view. Detail:
select u1.name,u2.name,decode(min(option$),1,'YES','NO') from sys.user$ u1, sys.user$ u2, sys.sysauth$ sa where grantee# in

   (select distinct(privilege#)
    from sys.sysauth$ sa
    where privilege# > 0
    connect by prior sa.privilege# = sa.grantee#     start with grantee#=userenv('SCHEMAID') or grantee#=1 or grantee# in

      (select kzdosrol from x$kzdos))
   and u1.user#=sa.grantee# and u2.user#=sa.privilege# group by u1.name,u2.name

Is this something that is a part of Dev2K, like FRM45_ENABLED_ROLES? It really does seem to me that if I log in as SYS to grant privileges on this, that should work; but then I think granting the privs to the *role* should work.

Thanks!

-- 
Teresa Redmond
Programmer/Analyst II
Anteon Corporation
tredmond at anteon dot com