plggrant.sql

Oracle PL/SQL procedure generator (second generator type)

REM
REM Run from SYS account or account with SYS-like privileges.
REM

GRANT CREATE SESSION TO &1;

REM Take care of the regular stuff
GRANT CREATE PROCEDURE TO &1;
GRANT CREATE TABLE TO &1;
GRANT CREATE VIEW TO &1;
GRANT CREATE SEQUENCE TO &1;

REM Just in case...
GRANT EXECUTE ON SYS.DBMS_SQL TO &1;

REM You may want to modify this, but the schema must have access
REM to at least 5MB of SYSTEM tablespace.
GRANT UNLIMITED TABLESPACE TO &1;

REM Needed to offer access from multiple schemas
GRANT CREATE PUBLIC SYNONYM TO &1;
GRANT DROP PUBLIC SYNONYM TO &1;
GRANT SELECT ANY TABLE TO &1;
GRANT SELECT ANY SEQUENCE TO &1;

REM Needed for [DEFARRAY]
GRANT CREATE ANY VIEW TO &1;

REM Needed for [DEFARRAY]
GRANT ALTER ANY PROCEDURE TO &1;
GRANT EXECUTE ANY PROCEDURE TO &1;