Rem 
Rem Name : tu60grnt.sql 
Rem Purpose : This script grants access to the CDE Tools Common Schema 
Rem 
Rem Owner : Installation and Release Group
Rem
Rem     Date     Modified by      Reason
Rem     ----     -----------      ------
Rem     12/15/94 gpadmana         Created
Rem     8/21/97  rmorin	   	    Commented out EXIT, taken care of by D2KGRNT.SQL 
Rem 

WHENEVER OSERROR  EXIT 32767
WHENEVER SQLERROR EXIT SQL.SQLCODE

spool %ORACLE_HOME%\TOOLS\DBTAB60\tu60grnt.lst
PROMPT Log spooled in ORACLE_HOME\TOOLS\DBTAB60\tu60grnt.lst

accept uname char prompt 'Grant access to user: ';

set verify off;

grant select, insert, update, delete on de_attached_libs to &uname;

grant select, insert, update, delete on gc_charting      to &uname;
grant select, insert, update, delete on gc_field         to &uname;
grant select, insert, update, delete on gc_reference     to &uname;

grant select                         on ROSSTRUCTS       to &uname;
grant select                         on ROSATTRIBS       to &uname;
grant select, insert, update, delete on ROSSTRINGS       to &uname;
grant select, insert, update, delete on ROSLFDESC        to &uname;
grant select, insert, update, delete on ROSTFDESC        to &uname;
grant select, insert, update, delete on ROSOBJMAP        to &uname;
grant select, insert, update, delete on ROSSEQUENCES     to &uname;
grant select                         on ROSLFDESC_ID     to &uname;
grant select                         on ROSTFDESC_ID     to &uname;

grant select, insert, update, delete on tool_access       to &uname;
grant select                         on tool_accessible   to &uname;

grant select                         on tool_modid        to &uname;
grant select                         on tool_lraw_id      to &uname;
grant select                         on tool_ltext_id     to &uname;
grant select, insert, update, delete on tool_module       to &uname;
grant select, insert, update, delete on tool_ltext        to &uname;
grant select, insert, update, delete on tool_lraw         to &uname;
grant select, insert, update, delete on tool_plsql        to &uname;
grant select, insert, update, delete on tool_comment      to &uname;
grant select, insert, update, delete on tool_library      to &uname;
grant select, insert, update, delete on tool_depend       to &uname;
grant select                         on tool_dependent    to &uname;
grant update (depchanged)            on tool_dependent    to &uname;

grant select, insert, update, delete on vg_drawing        to &uname;
grant select, insert, update, delete on vg_color          to &uname;
grant select, insert, update, delete on vg_font           to &uname;
grant select, insert, update, delete on vg_image          to &uname;

set verify on;

SPOOL OFF
REM exit;
