#!/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