Creation of Basic Role for Application Schema

SET SERVEROUTPUT ON
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 60
SET LINES 132

REM
REM
REM || Title : create_dev_role.sql
REM ||
REM || Purpose : Script that creates a basic role role for application schema. N.B other
REM || additional privs may be needed.
REM ||
REM || Variables : None
REM ||
REM || Schema : system
REM ||
REM ||
REM

UNDEFINE role_name

ACCEPT role_name PROMPT 'Enter username for schema owner : '


CREATE ROLE &&role_name

GRANT CREATE SESSION,
CREATE TABLE,
CREATE VIEW,
CREATE PROCEDURE,
CREATE SYNONYM,
CREATE DATABASE LINK,
CREATE SEQUENCE,
CREATE TRIGGER
TO &&role_name
/

 

SET SERVEROUTPUT ON
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 60

UNDEFINE role_name
This script is provided for educational purposes only. The script has been tested and appears to work as intended. However, you should always test any script before relying on it. No responsibility will be accepted for Lost or damage that may occur from it's use.