Re: Granting permissions to entire schema
Date: 26 Mar 1999 14:42:18 GMT
Message-ID: <01be779f$aba84670$2c289a0a_at_apollo>
Hello Mark
Make a script to create a script to do the job! I dont have the details ready, but this should give you an idea:
Use the following Oracle documented "tricks":
Create a script file (such as "grant_create.ql") with these lines:
set feedback off
set heading off
spool grants.sql
select 'grant select on '||table_name||' to USER;'
from user_tables, ... where ...
spool off
start grants.sql
Peter
Mark <mrittman_at_tmf-europe.com> skrev i artiklen
<36f8aaec.49605138_at_news.dial.pipex.com>...
> Does anyone know of a way of granting permissions (select, insert etc)
> on an entire schema, to a role or user?
>
> At the moment, it appears that permissions have to be granted on a
> table-by-table basis. Some of our schemas have *many* tables...!
>
> I'd be eternally grateful for any help
>
> Mark Rittman
> mrittman_at_tmf-europe.com
> Toyota Motor Finance
>
>
>
Received on Fri Mar 26 1999 - 15:42:18 CET