Re: newbie question about roles.

how about this:

spool filename.sql
select 'grant select, insert, update, delete on '||table_name||'to USER;' from user_tables;
select 'grant execute on '||object_name||' to USER;' from user_objects   where object_type in ('PROCEDURE','FUNCTION','PACKAGE'); spool off
@filename.sql

• this doesnt cover all of that new java classes, etc with 8i but its a good start.

joe
John Dunn wrote:
>
> I want to be able to grant insert, updates etc privileges on my schemas
> tables to new users. Presumably a role is the best way to do this.
>
> But when I create the role do I need to grant the privileges individually on
> each table. Is there any way to effectively say..."grant update on all
> tables owned by a schema"?
>
> John
>
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs