CREATE USER qdgl
IDENTIFIED BY "qdgl"
DEFAULT TABLESPACE qdgl
QUOTA unlimited ON qdgl
TEMPORARY TABLESPACE temp;
GRANT CREATE SESSION TO qdgl;
GRANT CREATE table TO qdgl;
GRANT CREATE VIEW TO qdgl;
GRANT CREATE TRIGGER TO qdgl;
GRANT CREATE database link TO qdgl;
GRANT CREATE public database link TO qdgl;
GRANT CREATE PROCEDURE to qdgl;
GRANT CREATE sequence to qdgl;
GRANT CREATE synonym to qdgl;
GRANT CREATE any directory to qdgl;
GRANT CREATE JOB to qdgl;
GRANT CREATE MATERIALIZED VIEW to qdgl;
GRANT CREATE index to qdgl;
GRANT select on v$sql_node_name to qdgl;
GRANT select on v$LOCK to qdgl;
GRANT select on v$CIPHERS to qdgl;
GRANT exec to kill_session to qdgl;
CREATE USER "qdgl" IDENTIFIED BY "qdglxxxxxx" HASH WITH SHA512 PASSWORD_POLICY 2 ENCRYPT BY "qdglxxxxxx"
limit failed_login_attemps 3, password_grace_time 10 DEFAULT TABLESPACE "qdgl" DEFAULT INDEX TABLESPACE "qdgl";
create user "FGSGB_R" identified by "******"
read only
limit failed_login_attemps 3, password_lock_time 1, password_grace_time 10
grant "PUBLIC","VTI" to "FGSGB_R";
GRANT CREATE database link TO POLICY_INCR;
GRANT CREATE database link TO POLICY_REINS;
GRANT CREATE database link TO POLICYRP_THR_BASE;
GRANT CREATE database link TO POLICYPR_THR_INC;
GRANT CREATE database link TO POLICYPR_THR_HIS;
GRANT CREATE database link TO POLICYRP_SEC_BASE;
GRANT CREATE database link TO POLICYRP_SEC_HIS;