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


Ready for Action?

LET'S GO!
Copyright 2024 IT Remote dot com
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram