SQL Codes

Create new profile P_UNLIMIT This profile P_UNLIMIT has all value set to unlimit and will temporary be used for account managements. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 CREATE PROFILE "P_UNLIMIT" LIMIT COMPOSITE_LIMIT UNLIMITED SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED LOGICAL_READS_PER_SESSION UNLIMITED LOGICAL_READS_PER_CALL UNLIMITED IDLE_TIME UNLIMITED CONNECT_TIME UNLIMITED PRIVATE_SGA UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED PASSWORD_VERIFY_FUNCTION NULL PASSWORD_LOCK_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED ; Unlock account oradba Unlock account oradba and set profile to P_ADMIN. ...

Show Oracle ACLs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 set line 160 pagesize 999 tab off trimspool off col host FORMAT A16 col l_port FORMAT 99999 col u_port FORMAT 99999 col start_date FORMAT A30 col end_date FORMAT A30 col principal FORMAT A20 col principal_type FORMAT A10 col privilege FORMAT A10 SELECT dha.host, dha.lower_port l_port, dha.upper_port u_port, dha.ace_order, dha.start_date, dha.end_date, dha.grant_type, dha.inverted_principal, dha.principal, dha.principal_type, dha.privilege FROM dba_host_aces dha ORDER BY dha.host, dha.ace_order ; Remove ACL Remove APEX_200200 ACL exampel for smtp port 25. ...