rem
rem $Header: /net/tools-build/build12/ros991/spam/precious/files/ACTIVE/rosgrnt.sql,v 1.1 1998/01/07 02:01:01 yxia Exp $
rem

rem  ---------------------------------------------------------------------
rem  Copyright (c) Oracle Corporation 1991.  All Rights Reserved, Worldwide.
rem
rem  NAME: rosgnt.sql
rem
rem  DESCRIPTION:
rem
rem  This script grants access to the Resource Object Store schema in a clients
rem  database (usually USER)
rem


Rem  Copyright (c) 1991 by Oracle Corporation
Rem    NAME
Rem      rosgrnt.sql - <one-line expansion of the name>
Rem    DESCRIPTION
Rem      Used with the ros tables, this script prompts for a
Rem      user to grant access to, and grants the appropriate access for
Rem      each table to that user.
Rem    RETURNS
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    MODIFIED   (MM/DD/YY)
Rem     dlai       11/24/92 -  Change access privilege to ROSSTRUCTS
Rem                            ROSATTRIBS, they only need select privilege
Rem     dlai       05/22/92 -  revise
Rem     dlai       03/25/92 -  Creation

accept uname char prompt 'Grant access to user: ';

set verify off;

grant select                         on ROSSTRUCTS    to &uname;
grant select                         on ROSATTRIBS    to &uname;
grant select, insert, update, delete on ROSSTRINGS    to &uname;
grant select, insert, update, delete on ROSLFDESC     to &uname;
grant select, insert, update, delete on ROSTFDESC     to &uname;
grant select, insert, update, delete on ROSOBJMAP     to &uname;
grant select, insert, update, delete on ROSSEQUENCES  to &uname;
grant select                         on ROSLFDESC_ID  to &uname;
grant select                         on ROSTFDESC_ID  to &uname;

set verify on;


