授权

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;