REM
REM  $Id: srw6grnt.sql,v 1.1 1998/11/03 07:00:41 yxia Exp $
REM
REM  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
REM
REM  srw2grnt.sql
REM
REM  Used with the centralized SRW tables, this script prompts for a
REM  user to grant access to, and then grants appropriate access on
REM  the SRW tables to that user.
REM

ACCEPT uname CHAR PROMPT 'Grant access to user: ';

SET VERIFY OFF;

GRANT SELECT                         ON srw2_module           TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_anchor           TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_boilerplate      TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_text_segment     TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_button           TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_column           TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_data_model       TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_field            TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_frame            TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_group_node       TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_group            TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_hyperlink        TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_format_exception TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_java_applet      TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_java_properties  TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_layout_group     TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_link             TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_layout           TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_body_location    TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_matrix           TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_og_document      TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_ogd_column_map   TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_param_form       TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_query            TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_element          TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_display_tag      TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_lists            TO &uname;
GRANT SELECT, INSERT, UPDATE, DELETE ON srw2_distribution     TO &uname;

SET VERIFY ON;

COMMIT;

