1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Alter Profile Urgent!!

Discussion in 'Server Administration and Options' started by Los Feliz, Jan 17, 2013.

  1. Los Feliz

    Los Feliz Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hello everybody,

    I'm auditing oracle11g, I would like to know if its possible to know if I will be able to alter the dba profiles without actually doing it. I mean I want to know first if I will be able to perform these actions, for example changing PASSWORD_LIFE_TIME xx, PASSWORD_GRACE_TIME xx, but without performing these actions in the database. I will apprecciate your reply of how can I check this.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    re: Alter Profile Urgent!! -- JUNK

    What, exactly, are you asking? Are you asking if altering a profile is a dynamic process, one that can be completed from the SQL> prompt without restarting the database? The answer to that is yes:

    Code (SQL):
    SQL> CREATE profile dba_junk LIMIT password_life_time unlimited;
     
    Profile created.
     
    SQL>
    SQL> SELECT * FROM dba_profiles WHERE profile = 'DBA_JUNK';
     
    PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
    ------------------------------ -------------------------------- -------- ----------------------
    DBA_JUNK                       COMPOSITE_LIMIT                  KERNEL   DEFAULT
    DBA_JUNK                       SESSIONS_PER_USER                KERNEL   DEFAULT
    DBA_JUNK                       CPU_PER_SESSION                  KERNEL   DEFAULT
    DBA_JUNK                       CPU_PER_CALL                     KERNEL   DEFAULT
    DBA_JUNK                       LOGICAL_READS_PER_SESSION        KERNEL   DEFAULT
    DBA_JUNK                       LOGICAL_READS_PER_CALL           KERNEL   DEFAULT
    DBA_JUNK                       IDLE_TIME                        KERNEL   DEFAULT
    DBA_JUNK                       CONNECT_TIME                     KERNEL   DEFAULT
    DBA_JUNK                       PRIVATE_SGA                      KERNEL   DEFAULT
    DBA_JUNK                       FAILED_LOGIN_ATTEMPTS            PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_LIFE_TIME               PASSWORD UNLIMITED
    DBA_JUNK                       PASSWORD_REUSE_TIME              PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_REUSE_MAX               PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_VERIFY_FUNCTION         PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_LOCK_TIME               PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_GRACE_TIME              PASSWORD DEFAULT
     
    16 ROWS selected.
     
    SQL>
    SQL> ALTER profile dba_junk LIMIT password_grace_time 7;
     
    Profile altered.
     
    SQL>
    SQL> SELECT * FROM dba_profiles WHERE profile = 'DBA_JUNK';
     
    PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
    ------------------------------ -------------------------------- -------- ----------------------
    DBA_JUNK                       COMPOSITE_LIMIT                  KERNEL   DEFAULT
    DBA_JUNK                       SESSIONS_PER_USER                KERNEL   DEFAULT
    DBA_JUNK                       CPU_PER_SESSION                  KERNEL   DEFAULT
    DBA_JUNK                       CPU_PER_CALL                     KERNEL   DEFAULT
    DBA_JUNK                       LOGICAL_READS_PER_SESSION        KERNEL   DEFAULT
    DBA_JUNK                       LOGICAL_READS_PER_CALL           KERNEL   DEFAULT
    DBA_JUNK                       IDLE_TIME                        KERNEL   DEFAULT
    DBA_JUNK                       CONNECT_TIME                     KERNEL   DEFAULT
    DBA_JUNK                       PRIVATE_SGA                      KERNEL   DEFAULT
    DBA_JUNK                       FAILED_LOGIN_ATTEMPTS            PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_LIFE_TIME               PASSWORD UNLIMITED
    DBA_JUNK                       PASSWORD_REUSE_TIME              PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_REUSE_MAX               PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_VERIFY_FUNCTION         PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_LOCK_TIME               PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_GRACE_TIME              PASSWORD 7
     
    16 ROWS selected.
     
    SQL>
    SQL> ALTER profile dba_junk LIMIT
      2  password_lock_time 1
      3  password_reuse_max 12
      4  password_reuse_time 180;
     
    Profile altered.
     
    SQL>
    SQL> SELECT * FROM dba_profiles WHERE profile = 'DBA_JUNK';
     
    PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
    ------------------------------ -------------------------------- -------- ----------------------
    DBA_JUNK                       COMPOSITE_LIMIT                  KERNEL   DEFAULT
    DBA_JUNK                       SESSIONS_PER_USER                KERNEL   DEFAULT
    DBA_JUNK                       CPU_PER_SESSION                  KERNEL   DEFAULT
    DBA_JUNK                       CPU_PER_CALL                     KERNEL   DEFAULT
    DBA_JUNK                       LOGICAL_READS_PER_SESSION        KERNEL   DEFAULT
    DBA_JUNK                       LOGICAL_READS_PER_CALL           KERNEL   DEFAULT
    DBA_JUNK                       IDLE_TIME                        KERNEL   DEFAULT
    DBA_JUNK                       CONNECT_TIME                     KERNEL   DEFAULT
    DBA_JUNK                       PRIVATE_SGA                      KERNEL   DEFAULT
    DBA_JUNK                       FAILED_LOGIN_ATTEMPTS            PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_LIFE_TIME               PASSWORD UNLIMITED
    DBA_JUNK                       PASSWORD_REUSE_TIME              PASSWORD 180
    DBA_JUNK                       PASSWORD_REUSE_MAX               PASSWORD 12
    DBA_JUNK                       PASSWORD_VERIFY_FUNCTION         PASSWORD DEFAULT
    DBA_JUNK                       PASSWORD_LOCK_TIME               PASSWORD 1
    DBA_JUNK                       PASSWORD_GRACE_TIME              PASSWORD 7
     
    16 ROWS selected.
     
    SQL>
    For the affected users of this profile the changes will not take effect until they start a new session -- they will need to either logout and login or reconnect using connect user/pass syntax.