Re: GRANT Help

Hi, try this

..      select 'grant priv1,priv2....privn'|| ' on ' ||object_name||
              ' to role_name '||';'
           from user_objects 
                 

what ive done here is to use a select statement to generate sql ie sql generating sql the syntax is not perfect but it should give you an idea. In sql*plus put the select in a spool file by putting the spool command and file name before the select and after the select you spool off Then you run the script thus _at_filename.sql note the whole script is saved in the file you create if file in other path you must specify.   Received on Wed May 15 1996 - 00:00:00 CEST