rem
rem  $Header: /net/tools-build/build12/ros991/spam/precious/files/ACTIVE/toolrvke.sql,v 1.1 1998/01/07 02:02:13 yxia Exp $
rem
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem
rem  toolrvke.sql
rem
rem  Used with the centralized tools tables, this script prompts for a
rem  user to grant access to, and revokes all access for each table
rem  from that user.
rem

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

set verify off;
revoke all on tool_access       from &uname;
revoke all on tool_accessible   from &uname;
revoke all on tool_library      from &uname;
revoke all on tool_module       from &uname;
revoke all on tool_ltext        from &uname;
revoke all on tool_lraw         from &uname;
revoke all on tool_plsql        from &uname;
revoke all on tool_comment      from &uname;
revoke all on tool_depend       from &uname;
revoke all on tool_dependent    from &uname;
revoke all on tool_modid        from &uname;
revoke all on tool_lraw_id      from &uname;
revoke all on tool_ltext_id     from &uname;
set verify on;

