rem
rem  $Id: degrnt.sql,v 1.1 1998/01/08 01:44:49 yxia Exp $
rem
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem 
rem  degrnt.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

rem  NOTE:
rem  degrnt.sql must be run for each of the user used in DE regression:
rem    i.e., de, de_unpriv, and de_priv
rem

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

set verify off;

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

rem
rem  ALTER SESSION is required for server-side debugging, and also to
rem  set the session to 'signature mode'.
rem
grant alter session to &uname;

set verify on;