-- connect as sysdba
---------------------------------------

col property_name for a40
col property_value for a15
col description for a40
set linesize 140

---------------------------------------

-- DROP USER USERNAME CASCADE;

---------------------------------------
---------------------------------------

CREATE USER USERNAME IDENTIFIED BY PASSWORD;
ALTER USER USERNAME DEFAULT TABLESPACE NEWTBS TEMPORARY TABLESPACE TEMPNEWTBS;
ALTER USER USERNAME ACCOUNT UNLOCK;
GRANT CONNECT TO USERNAME;
GRANT DBA TO USERNAME;
GRANT UNLIMITED TABLESPACE TO USERNAME;
ALTER USER USERNAME DEFAULT ROLE ALL;

GRANT ALTER ANY CLUSTER TO USERNAME;
GRANT ALTER ANY INDEX TO USERNAME;
GRANT ALTER ANY LIBRARY TO USERNAME;
GRANT ALTER ANY PROCEDURE TO USERNAME;
GRANT ALTER ANY ROLE TO USERNAME;
GRANT ALTER ANY SEQUENCE TO USERNAME;
GRANT ALTER ANY SNAPSHOT TO USERNAME;
GRANT ALTER ANY TABLE TO USERNAME;
GRANT ALTER ANY TRIGGER TO USERNAME;
GRANT ALTER ANY TYPE TO USERNAME;
GRANT ALTER DATABASE TO USERNAME;
GRANT ALTER PROFILE TO USERNAME;
GRANT ALTER RESOURCE COST TO USERNAME;
GRANT ALTER ROLLBACK SEGMENT TO USERNAME;
GRANT ALTER SESSION TO USERNAME;
GRANT ALTER SYSTEM TO USERNAME;
GRANT ALTER TABLESPACE TO USERNAME;
GRANT ALTER USER TO USERNAME;
GRANT ANALYZE ANY TO USERNAME;
GRANT AUDIT ANY TO USERNAME;
GRANT AUDIT SYSTEM TO USERNAME;
GRANT BACKUP ANY TABLE TO USERNAME;
GRANT BECOME USER TO USERNAME;
GRANT COMMENT ANY TABLE TO USERNAME;
GRANT CREATE ANY CLUSTER TO USERNAME;
GRANT CREATE ANY DIRECTORY TO USERNAME;
GRANT CREATE ANY INDEX TO USERNAME;
GRANT CREATE ANY LIBRARY TO USERNAME;
GRANT CREATE ANY PROCEDURE TO USERNAME;
GRANT CREATE ANY SEQUENCE TO USERNAME;
GRANT CREATE ANY SNAPSHOT TO USERNAME;
GRANT CREATE ANY SYNONYM TO USERNAME;
GRANT CREATE ANY TABLE TO USERNAME;
GRANT CREATE ANY TRIGGER TO USERNAME;
GRANT CREATE ANY TYPE TO USERNAME;
GRANT CREATE ANY VIEW TO USERNAME;
GRANT CREATE CLUSTER TO USERNAME;
GRANT CREATE DATABASE LINK TO USERNAME;
GRANT CREATE LIBRARY TO USERNAME;
GRANT CREATE PROCEDURE TO USERNAME;
GRANT CREATE PROFILE TO USERNAME;
GRANT CREATE PUBLIC DATABASE LINK TO USERNAME;
GRANT CREATE PUBLIC SYNONYM TO USERNAME;
GRANT CREATE ROLE TO USERNAME;
GRANT CREATE ROLLBACK SEGMENT TO USERNAME;
GRANT CREATE SEQUENCE TO USERNAME;
GRANT CREATE SESSION TO USERNAME;
GRANT CREATE SNAPSHOT TO USERNAME;
GRANT CREATE SYNONYM TO USERNAME;
GRANT CREATE TABLE TO USERNAME;
GRANT CREATE TABLESPACE TO USERNAME;
GRANT CREATE TRIGGER TO USERNAME;
GRANT CREATE TYPE TO USERNAME;
GRANT CREATE USER TO USERNAME;
GRANT CREATE VIEW TO USERNAME;
GRANT DELETE ANY TABLE TO USERNAME;
GRANT DROP ANY CLUSTER TO USERNAME;
GRANT DROP ANY DIRECTORY TO USERNAME;
GRANT DROP ANY INDEX TO USERNAME;
GRANT DROP ANY LIBRARY TO USERNAME;
GRANT DROP ANY PROCEDURE TO USERNAME;
GRANT DROP ANY ROLE TO USERNAME;
GRANT DROP ANY SEQUENCE TO USERNAME;
GRANT DROP ANY SNAPSHOT TO USERNAME;
GRANT DROP ANY SYNONYM TO USERNAME;
GRANT DROP ANY TABLE TO USERNAME;
GRANT DROP ANY TRIGGER TO USERNAME;
GRANT DROP ANY TYPE TO USERNAME;
GRANT DROP ANY VIEW TO USERNAME;
GRANT DROP PROFILE TO USERNAME;
GRANT DROP PUBLIC DATABASE LINK TO USERNAME;
GRANT DROP PUBLIC SYNONYM TO USERNAME;
GRANT DROP ROLLBACK SEGMENT TO USERNAME;
GRANT DROP TABLESPACE TO USERNAME;
GRANT DROP USER TO USERNAME;
GRANT EXECUTE ANY LIBRARY TO USERNAME;
GRANT EXECUTE ANY PROCEDURE TO USERNAME;
GRANT EXECUTE ANY TYPE TO USERNAME;
GRANT FORCE ANY TRANSACTION TO USERNAME;
GRANT FORCE TRANSACTION TO USERNAME;
GRANT GRANT ANY PRIVILEGE TO USERNAME;
GRANT GRANT ANY ROLE TO USERNAME;
GRANT INSERT ANY TABLE TO USERNAME;
GRANT LOCK ANY TABLE TO USERNAME;
GRANT MANAGE TABLESPACE TO USERNAME;
GRANT RESTRICTED SESSION TO USERNAME;
GRANT SELECT ANY SEQUENCE TO USERNAME;
GRANT SELECT ANY TABLE TO USERNAME;
GRANT UPDATE ANY TABLE TO USERNAME;

PROMPT Zugriff auf DBA_JOBS_RUNNING vergeben
GRANT SELECT ON DBA_JOBS_RUNNING TO USERNAME;

PROMPT Zugriff auf V_$PARAMETER vergeben
GRANT SELECT ON V_$PARAMETER TO USERNAME;

PROMPT ZUgriff auf GV_$SESSION vergeben
GRANT SELECT ON GV_$SESSION  TO USERNAME;

commit;

---------------------------------------

PROMPT granted SYS-Tabellen für DC
PROMPT Aufruf als DBA

GRANT SELECT ON SYS.DBA_JOBS_RUNNING TO USERNAME;
GRANT SELECT ON SYS.GV_$SESSION TO USERNAME;
GRANT SELECT ON SYS.v_$SESSTAT TO USERNAME;
GRANT SELECT ON SYS.v_$STATNAME TO USERNAME;

GRANT SELECT ON SYS.DBA_USERS TO USERNAME;
GRANT SELECT ON SYS.ALL_TAB_COLUMNS TO USERNAME;
GRANT SELECT ON SYS.USER_TRIGGERS TO USERNAME;

commit;

---------------------------------------

-- script ausführen

---------------------------------------

@%ORACLE_HOME%\sqlplus\admin\pupbld.sql

commit;