Re: Granting permissions to entire schema

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 ...

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