Re: [Q] way to re-gernerate ROLE privilege ?

  • From: Thomas Day <tomday2@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 10 May 2005 08:43:45 -0400

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')
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2005