Home » RDBMS Server » Server Administration » What is Oracle Profile?
What is Oracle Profile? [message #61595] Fri, 07 May 2004 03:56 Go to next message
ramnavi
Messages: 2
Registered: May 2004
Junior Member
Pl. enlightening me on Oracle Profile file and its parameters.
Re: What is Oracle Profile? [message #61599 is a reply to message #61595] Fri, 07 May 2004 23:18 Go to previous messageGo to next message
Frank Naude
Messages: 4580
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
Re: What is Oracle Profile? [message #61610 is a reply to message #61599] Mon, 10 May 2004 21:46 Go to previous message
ramnavi
Messages: 2
Registered: May 2004
Junior Member
Thank you very much for the reply.
Previous Topic: Oracle Database Creation
Next Topic: help urgent
Goto Forum:
  


Current Time: Fri Sep 20 12:24:00 CDT 2024