rem  Copyright (c) 1992 by Oracle Corporation
rem    NAME
rem      rosrvke.sql - ROS revoke privilege script
rem    DESCRIPTION
rem      revokes all access for each table from that user.
rem    RETURNS
rem
rem    NOTES
rem
rem    MODIFIED   (MM/DD/YY)
rem     dlai       01/29/93 -  Creation

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

set verify off;

revoke all on ROSSTRUCTS    from &uname;
revoke all on ROSATTRIBS    from &uname;
revoke all on ROSSTRINGS    from &uname;
revoke all on ROSLFDESC     from &uname;
revoke all on ROSTFDESC     from &uname;
revoke all on ROSOBJMAP     from &uname;
revoke all on ROSSEQUENCES  from &uname;
revoke all on ROSLFDESC_ID  from &uname;
revoke all on ROSTFDESC_ID  from &uname;

set verify on;

