rem 
rem $Id: gcrvke.sql,v 1.1 1998/01/02 23:20:21 bgutierr Exp $
rem 
Rem  Copyright (c) 1992 by Oracle Corporation 
Rem    NAME
Rem      gcrvke.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 gc_charting   from &uname;
revoke all on gc_field      from &uname;
revoke all on gc_reference  from &uname;

set verify on;
