informatica:oracle:comandos
This is an old revision of the document!
Comprobar usuario bloqueado:
select username,account_status,profile from dba_users where username='jose' USERNAME ACCOUNT_STATUS PROFILE ------------------------------ -------------------------------- ------------------------------ jose LOCKED(TIMED) DEFAULT
Desbloquear usuario:
ALTER USER username ACCOUNT UNLOCK;
Comprobar parámetros perfil usuario:
SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT'; RESOURCE_NAME RESOURCE LIMIT -------------------------------- -------- ---------------------------------------- COMPOSITE_LIMIT KERNEL UNLIMITED SESSIONS_PER_USER KERNEL UNLIMITED CPU_PER_SESSION KERNEL UNLIMITED CPU_PER_CALL KERNEL UNLIMITED LOGICAL_READS_PER_SESSION KERNEL UNLIMITED LOGICAL_READS_PER_CALL KERNEL UNLIMITED IDLE_TIME KERNEL UNLIMITED CONNECT_TIME KERNEL UNLIMITED PRIVATE_SGA KERNEL UNLIMITED FAILED_LOGIN_ATTEMPTS PASSWORD 10 PASSWORD_LIFE_TIME PASSWORD UNLIMITED PASSWORD_REUSE_TIME PASSWORD UNLIMITED PASSWORD_REUSE_MAX PASSWORD UNLIMITED PASSWORD_VERIFY_FUNCTION PASSWORD NULL PASSWORD_LOCK_TIME PASSWORD 1 PASSWORD_GRACE_TIME PASSWORD 7
informatica/oracle/comandos.1373292091.txt.gz · Last modified: 2015/04/13 20:19 (external edit)