rem 
rem $Id: vggrnt.sql,v 1.1 1998/01/02 23:38:52 bgutierr Exp $
rem 
Rem  Copyright (c) 1992 by Oracle Corporation 
Rem    NAME
Rem      vggrnt.sql - <one-line expansion of the name>
Rem    DESCRIPTION
Rem      Used with the vgs 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    RETURNS
Rem 
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    MODIFIED   (MM/DD/YY)
Rem     ewong      03/30/93 -  Removed exit statement 
Rem     fpun       12/04/92 -  add exit; 
Rem     fpun       11/24/92 -  Creation 
Rem     dlai       03/25/92 -  Creation 

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

set verify off;

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; 
