Ameer Khan

Create a profile with unlimited access and other unlimited privileges in Oracle 11g

SQL> CREATE PROFILE “NEW” LIMIT
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
CONNECT_TIME UNLIMITED
IDLE_TIME UNLIMITED
SESSIONS_PER_USER UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
PRIVATE_SGA UNLIMITED
COMPOSITE_LIMIT UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_LOCK_TIME UNLIMITED
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL;

Profile created.

SQL> select * from dba_profiles WHERE PROFILE=’NEW’;

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT

—————————— ——————————– ——– —————————————-

NEW                           COMPOSITE_LIMIT                  KERNEL   UNLIMITED

NEW                           SESSIONS_PER_USER                KERNEL   UNLIMITED

NEW                           CPU_PER_SESSION                  KERNEL   UNLIMITED

NEW                           CPU_PER_CALL                     KERNEL   UNLIMITED

NEW                           LOGICAL_READS_PER_SESSION        KERNEL   UNLIMITED

NEW                           LOGICAL_READS_PER_CALL           KERNEL   UNLIMITED

NEW                           IDLE_TIME                        KERNEL   UNLIMITED

NEW                           CONNECT_TIME                     KERNEL   UNLIMITED

NEW                           PRIVATE_SGA                      KERNEL   UNLIMITED

NEW                           FAILED_LOGIN_ATTEMPTS            PASSWORD UNLIMITED

NEW                           PASSWORD_LIFE_TIME               PASSWORD UNLIMITED

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT

—————————— ——————————– ——– —————————————-

NEW                           PASSWORD_REUSE_TIME              PASSWORD UNLIMITED

NEW                           PASSWORD_REUSE_MAX               PASSWORD UNLIMITED

NEW                           PASSWORD_VERIFY_FUNCTION         PASSWORD NULL

NEW                           PASSWORD_LOCK_TIME               PASSWORD UNLIMITED

NEW                           PASSWORD_GRACE_TIME              PASSWORD UNLIMITED

Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.