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

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.

Nenhum comentário:

Postar um comentário

Related Posts Plugin for WordPress, Blogger...