Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : HQ : Oracle

Script to create oracle user for hq manually by command prompt

Log-in the oracle system user in command prompt and run this following script




DROP USER RAYMEDI_HQ CASCADE;
DROP USER T_RAYMEDI_HQ_DUMP CASCADE;
DROP USER RAYMEDI_AUD CASCADE;
DROP USER RAYMEDI_CS CASCADE;


CREATE USER "RAYMEDI_HQ" PROFILE "DEFAULT" IDENTIFIED BY "RAYMEDI_HQ" DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "RAYMEDI_HQ";
GRANT "DBA" TO "RAYMEDI_HQ";
GRANT CREATE TABLE TO "RAYMEDI_HQ";
GRANT CREATE ANY INDEX TO "RAYMEDI_HQ";
GRANT CREATE ANY PROCEDURE TO "RAYMEDI_HQ";
GRANT CREATE ANY TRIGGER TO "RAYMEDI_HQ";


CREATE USER "RAYMEDI_CS" PROFILE "DEFAULT" IDENTIFIED BY "RAYMEDI_HQ" DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "RAYMEDI_CS";
GRANT "DBA" TO "RAYMEDI_CS";
GRANT CREATE TABLE TO "RAYMEDI_CS";
GRANT CREATE ANY INDEX TO "RAYMEDI_CS";
GRANT CREATE ANY PROCEDURE TO "RAYMEDI_CS";
GRANT CREATE ANY TRIGGER TO "RAYMEDI_CS";

CREATE USER "T_RAYMEDI_HQ_DUMP" PROFILE "DEFAULT" IDENTIFIED BY "RAYMEDI_HQ" DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "T_RAYMEDI_HQ_DUMP";
GRANT "DBA" TO "T_RAYMEDI_HQ_DUMP";
GRANT CREATE ANY INDEX TO "T_RAYMEDI_HQ_DUMP";
GRANT CREATE ANY PROCEDURE TO "T_RAYMEDI_HQ_DUMP";
GRANT CREATE ANY TRIGGER TO "T_RAYMEDI_HQ_DUMP";


CREATE USER "RAYMEDI_AUD" PROFILE "DEFAULT" IDENTIFIED BY "RAYMEDI_HQ" DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "RAYMEDI_AUD";
GRANT "DBA" TO "RAYMEDI_AUD";
GRANT CREATE ANY INDEX TO "RAYMEDI_AUD";
GRANT CREATE ANY PROCEDURE TO "RAYMEDI_AUD";
GRANT CREATE ANY TRIGGER TO "RAYMEDI_AUD";

commit;
exit;




Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB