Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] way to re-gernerate ROLE privilege ?
If you just need the table privs for the role, this will do. Give it
the role name.
SELECT 'GRANT '||privilege||' on '||owner||'.'||TABLE_NAME||' TO '||grantee=
||
=09decode(grantable,'YES',' with grant option;',';')
=09FROM dba_tab_privs
WHERE grantee=3Dupper('&&1')
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 10 2005 - 08:48:22 CDT
![]() |
![]() |