Chapter 16. Managing Password Security and Resources


Terms you'll need to understand:

  • FAILED_LOGIN_ATTEMPTS

  • PASSWORD_LOCK_TIME

  • PASSWORD_LIFE_TIME

  • PASSWORD_GRACE_TIME

  • EXPIRED

  • ACCOUNT LOCK

  • ACCOUNT UNLOCK

  • PASSWORD_REUSE_TIME

  • PASSWORD_REUSE_MAX

  • PASSWORD_VERIFY_FUNCTION

  • DEFAULT profile

  • RESOURCE_LIMIT

  • SESSIONS_PER_USER

  • CPU_PER_SESSION

  • CPU_PER_CALL

  • LOGICAL_READS_PER_SESSION

  • PRIVATE_SGA

  • LOGICAL_READS_PER_CALL

  • IDLE_TIME

  • CONNECT_TIME

  • COMPOSITE_LIMIT

  • ADMINISTER_RESOURCE_MANAGER

  • DBMS_RESOURCE_MANAGER

  • Pending area

  • Resource consumer groups

  • Resource plans

  • Resource directives

Concepts you'll need to master:

  • Manage passwords using profiles.

  • Administer profiles.

  • Control use of resources using profiles.

  • Obtain information about profiles, password management, and resources from the data dictionary.

Profiles are named sets of specific resource limits that can be assigned to any valid username or schema in an Oracle database. They provide a mechanism to more easily manage resource limits and password policies. This chapter provides information on using profiles to make your life as a DBA simpler.

Often it is necessary to carefully manage resource limits and user passwords. When this is the caseand let's face it, you aren't likely to be told that every user on your system should have free reign to use as much CPU and memory as she canyou can use profiles as a means to manage your resources from within the database. To use profiles, you first need to categorize related types of users in a database. Then determine how many profiles are needed at this point (you can always change it later) to be able to manage and provide equitable resources for all your different types of users. Then you must determine appropriate resource limits for each profile. Now let's get into some more detail.



    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net