|
Re: What is Oracle Profile? [message #61599 is a reply to message #61595] |
Fri, 07 May 2004 23:18 |
Frank Naude
Messages: 4587 Registered: April 1998
|
Senior Member |
|
|
Hi,
Profiles are used to limit resource usage and enforce password security for database users. This is documented in the SQL Reference Guide. Example usage:
SQL> conn / as sysdba
Connected.
SQL>
SQL> alter system set resource_limit = TRUE scope = both;
System altered.
SQL>
SQL> create profile batch_profile
2 LIMIT
3 idle_time 10
4 sessions_per_user 1
5 /
Profile created.
SQL>
SQL> create user batch identified by batch
2 profile batch_profile;
User created.
SQL>
SQL> select * from dba_profiles where profile = 'BATCH_PROFILE';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------------------- -------- ----------
BATCH_PROFILE COMPOSITE_LIMIT KERNEL DEFAULT
BATCH_PROFILE SESSIONS_PER_USER KERNEL 1
BATCH_PROFILE CPU_PER_SESSION KERNEL DEFAULT
BATCH_PROFILE CPU_PER_CALL KERNEL DEFAULT
BATCH_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT
BATCH_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT
BATCH_PROFILE IDLE_TIME KERNEL 10
BATCH_PROFILE CONNECT_TIME KERNEL DEFAULT
BATCH_PROFILE PRIVATE_SGA KERNEL DEFAULT
BATCH_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD DEFAULT
BATCH_PROFILE PASSWORD_LIFE_TIME PASSWORD DEFAULT
BATCH_PROFILE PASSWORD_REUSE_TIME PASSWORD DEFAULT
BATCH_PROFILE PASSWORD_REUSE_MAX PASSWORD DEFAULT
BATCH_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT
BATCH_PROFILE PASSWORD_LOCK_TIME PASSWORD DEFAULT
BATCH_PROFILE PASSWORD_GRACE_TIME PASSWORD DEFAULT
16 rows selected.
Best regards.
Frank
|
|
|
|