rem 
rem $Id: vgrvke.sql,v 1.1 1998/01/02 23:46:46 bgutierr Exp $
rem 
Rem  Copyright (c) 1992 by Oracle Corporation 
Rem    NAME
Rem      vgrvke.sql - <one-line expansion of the name>
Rem    DESCRIPTION
Rem      revokes all access for each table from 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 

accept uname char prompt 'Revoke access from user: ';

set verify off;

revoke all on vg_drawing    from &uname;
revoke all on vg_color      from &uname;
revoke all on vg_font       from &uname;
revoke all on vg_image      from &uname;

set verify on; 
