rem 
rem $Id: gorvke.sql,v 1.1 1998/01/02 23:26:26 bgutierr Exp $
rem 
Rem  Copyright (c) 1992 by Oracle Corporation 
Rem    NAME
Rem      gorvke.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 go_document   from &uname;
revoke all on go_timer      from &uname;
revoke all on go_parameter  from &uname;
revoke all on go_query      from &uname;
revoke all on go_vislayer   from &uname;
revoke all on go_sound      from &uname;

set verify on;

