rem 
rem $Header: /s/if/994/spam/precious/files/ACTIVE/frm4grnt.sql,v 1.1 1999/01/06 21:31:13 oraforms Exp $ 
rem 
Rem  Copyright (c) 1991 by Oracle Corporation 
Rem    NAME
Rem      frmgrant.sql - <one-line expansion of the name>
Rem    DESCRIPTION
Rem      Grant user access to the Forms views
Rem    RETURNS
Rem 
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    MODIFIED   (MM/DD/YY)
Rem     kyue       08/24/93 -  grant update 
Rem     smuench    08/22/93 -  Rem out Grants on Views 
Rem     kyue       08/18/93 -  grant privilege to the base table libextloc 
Rem     kyue       07/15/93 -  grant select, insert, delete on base tables to u
Rem     kyue       05/04/93 -  remove grant to doc 
Rem     fdancs     01/22/93 -  Don't grant insert,update,delete to mnugrp,mnuus
Rem     rgiljum    12/07/92 -  Creation 
Rem     kmallory   10/12/92 - #(124198) use &1 
Rem     bhill      09/04/92 -  scrollbar work 
Rem     kyue       07/22/92 -  adding table for library external location 
Rem     kmallory   05/28/92 -  Creation 

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

set verify off;

Rem
Rem grant select, insert, delete privilege to speed up the saving and loading
Rem
Rem We issue the grants against the public synonyms, but the
Rem privs get recorded against the corresponding base tables.
Rem
grant select, insert, delete, update on FRM40_REF          to &uname; 
grant select, insert, delete, update on FRM40_TEXT         to &uname;
grant select, insert, delete, update on FRM40_APP          to &uname;
grant select, insert, delete, update on FRM40_BLK          to &uname;
grant select, insert, delete, update on FRM40_RELATION     to &uname;
grant select, insert, delete, update on FRM40_TRG          to &uname;
grant select, insert, delete, update on FRM40_V2TRG        to &uname;
grant select, insert, delete, update on FRM40_ITM          to &uname;
grant select, insert, delete, update on FRM40_RBT          to &uname;
grant select, insert, delete, update on FRM40_ALERT        to &uname;
grant select, insert, delete, update on FRM40_LOV          to &uname;
grant select, insert, delete, update on FRM40_LOVCOL       to &uname;
grant select, insert, delete, update on FRM40_RGPCOL       to &uname;
grant select, insert, delete, update on FRM40_EDITOR       to &uname;
grant select, insert, delete, update on FRM40_GRP          to &uname;
grant select, insert, delete, update on FRM40_RGP          to &uname;
grant select, insert, delete, update on FRM40_FRMPAR       to &uname;
grant select, insert, delete, update on FRM40_VA           to &uname;
grant select, insert, delete, update on FRM40_VIEW         to &uname;
grant select, insert, delete, update on FRM40_WINDOW       to &uname;
grant select, insert, delete, update on FRM40_NAMELIST     to &uname;
grant select, insert, delete, update on FRM40_VS           to &uname;
grant select, insert, delete, update on FRM40_SB           to &uname;
grant select, insert, delete, update on FRM40_MNUAPP       to &uname;
grant select, insert, delete, update on FRM40_MNUMNU       to &uname;
grant select, insert, delete, update on FRM40_MNUITM       to &uname;
grant select, insert, delete, update on FRM40_MNUPAR       to &uname;
grant select, insert, delete, update on FRM40_LIBEXTLOC    to &uname;
grant select                         on FRM40_MNUUSER      to &uname;
grant select                         on FRM40_MNUGRP       to &uname;
