Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: newbie question about roles.

Re: newbie question about roles.

From: Rajiv Gangadharan <Rajiv.Gangadharan_at_alltel.com>
Date: Fri, 04 Aug 2000 5:37 -0500
Message-Id: <10579.113836@fatcity.com>

       no
       You will have to create a dynamic sql of the type
       select 'grant update on`|| table_name ||'to username;` from
       dba_tables where owner = 'schema name`;
       this when run and spooled will create a script which can be run
       to give the permission to the username/rolename for
       all tables.
       Rajiv
Received on Fri Aug 04 2000 - 05:37:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US