[code language=”sql”]

#!/bin/ksh
#
# Michael Culp
# Schema for the database relationship
# DBA01 Schema is for the DBAdmin App to be built
#
################################################################################
sqlplus -s "/ as sysdba" <<EOF
set serveroutput on size 1000000
set timing on;

drop user dba01 cascade;

create user dba01 identified by password
default tablespace users;

grant dba to dba01;
grant resource to dba01;

— drop table dba01.server;

— create table dba01.server (
— domain varchar2(50),
— hostname varchar2(100),
— database varchar2(200),
— env varchar2(15),
— aitno varchar2(20),
— app varchar2(35),
— rdbmsver varchar2(50),
— prim_dba varchar2(50)
— )
— tablespace brain_tbs;

DROP USER HC_CORE CASCADE;

CREATE USER HC_CORE
IDENTIFIED BY password
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
— 1 System Privilege for HC_CORE
GRANT CREATE SESSION TO HC_CORE;
— 20 Object Privileges for HC_CORE
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_BACKUP TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DATABASE TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_COMP TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_FRA TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_INIT_PARAM TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_INVLD_OBJECTS TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_OH_PATCHES TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_PATCHES TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_SPACE_USAGE TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_STANDBY_DEST TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_STANDBY_STATUS TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_TAB TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_INSTANCE TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_JOB_RUN TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_MACHINE TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_RMAN_BACKUP TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_STORAGE TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_SYSCTL_CONF TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_TBSPC TO HC_CORE;
— GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_TBSPC_DATAFILE TO HC_CORE;

EOF

[/code]