REM
REM  $Id: srw6rvke.sql,v 1.2 1999/01/11 20:37:06 dtrichar Exp $
REM
REM  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
REM
REM  srw2rvke.sql
REM
REM  Used with the centralized SRW tables, this script prompts for a
REM  user to revoke access from, and revoke all access from that user.
REM

ACCEPT uname CHAR PROMPT 'Revoke access from user: ';

SET VERIFY OFF;

REVOKE ALL ON srw2_module           FROM &uname;
REVOKE ALL ON srw2_anchor           FROM &uname;
REVOKE ALL ON srw2_boilerplate      FROM &uname;
REVOKE ALL ON srw2_text_segment     FROM &uname;
REVOKE ALL ON srw2_button           FROM &uname;
REVOKE ALL ON srw2_column           FROM &uname;
REVOKE ALL ON srw2_data_model       FROM &uname;
REVOKE ALL ON srw2_field            FROM &uname;
REVOKE ALL ON srw2_frame            FROM &uname;
REVOKE ALL ON srw2_group_node       FROM &uname;
REVOKE ALL ON srw2_group            FROM &uname;
REVOKE ALL ON srw2_hyperlink        FROM &uname;
REVOKE ALL ON srw2_format_exception FROM &uname;
REVOKE ALL ON srw2_java_applet      FROM &uname;
REVOKE ALL ON srw2_java_properties  FROM &uname;
REVOKE ALL ON srw2_layout_group     FROM &uname;
REVOKE ALL ON srw2_link             FROM &uname;
REVOKE ALL ON srw2_layout           FROM &uname;
REVOKE ALL ON srw2_body_location    FROM &uname;
REVOKE ALL ON srw2_matrix           FROM &uname;
REVOKE ALL ON srw2_og_document      FROM &uname;
REVOKE ALL ON srw2_ogd_column_map   FROM &uname;
REVOKE ALL ON srw2_param_form       FROM &uname;
REVOKE ALL ON srw2_query            FROM &uname;
REVOKE ALL ON srw2_element          FROM &uname;
REVOKE ALL ON srw2_display_tag      FROM &uname;
REVOKE ALL ON srw2_lists            FROM &uname;
REVOKE ALL ON srw2_distribution     FROM &uname;

SET VERIFY ON;

COMMIT;

