rem
rem  $Header: /net/tools-build/build12/ros991/spam/precious/files/ACTIVE/toolgrnt.sql,v 1.1 1998/01/07 02:02:12 yxia Exp $
rem
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem
rem  toolgrnt.sql
rem
rem  Used with the centralized tools tables, this script prompts for a
rem  user to grant access to, and grants the appropriate access for
rem  each table to that user.
rem

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

set verify off;

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;

set verify on;

