在這裡編輯新頁面「首頁/2022-11-16」
SELECT username,password,account_status,profile FROM dba_users where username='&USERNAME'
SQL> SELECT username,password,account_status,profile FROM dba_users where username='&USERNAME'; old 1: SELECT username,password,account_status,profile FROM dba_users where username='&USERNAME' new 1: SELECT username,password,account_status,profile FROM dba_users where username='SYS' USERNAME PASSWORD ACCOUNT_STATUS PROFILE ------------------------------ ------------------------------ -------------------------------- ------------------------------ SYS OPEN DEFAULT
- SELECT * from dba_profiles where PROFILE='DEFAULT';
SQL> SELECT * from dba_profiles where PROFILE='DEFAULT'; PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP ------------------------------ -------------------------------- -------- -------------------------------------------------- --- --- --- DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NO DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED NO NO NO DEFAULT CPU_PER_SESSION KERNEL UNLIMITED NO NO NO DEFAULT CPU_PER_CALL KERNEL UNLIMITED NO NO NO DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NO DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NO DEFAULT IDLE_TIME KERNEL UNLIMITED NO NO NO DEFAULT CONNECT_TIME KERNEL UNLIMITED NO NO NO DEFAULT PRIVATE_SGA KERNEL UNLIMITED NO NO NO DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10 NO NO NO DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 NO NO NO PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP ------------------------------ -------------------------------- -------- -------------------------------------------------- --- --- --- DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NO DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NO DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL NO NO NO DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 NO NO NO DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 NO NO NO DEFAULT INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NO 17 rows selected.