06)Briefly describe what is Profile? (10 Points)
After a profile has been created, the database administrator can assign it to each user. If resource limits are enabled, the database server limits the database usage and resources to the defined profile of the user. DEFAULT PROFILE: •The database server automatically creates a DEFAULT profile when the database is created. •The users who have not been explicitly assigned a specific profile conform to all the limits of the DEFAULT profile. •All limits of the DEFAULT profile are initially unlimited. •The database administrator can change the values so that limits are applied to all users by default. Profile Usage •Restrict users from performing some operations that require heavy use of resources •Ensure that users log off the database when they have left their session idle for some time •Enable group resource limits for similar users •Easily assign resource limits for users •Manage resource usage in large,,complex multiuser database systems •Control the use of passwords Profile Characteristics •Profile assignments do not effect current sessions. •Profile can be assigned only to users and not to roles or other profiles. •If you do not assign a profile when creating a user, the user is automatically assigned the DEFAULT profile 07)Briefly describe how to enable password management? (10 Points) ANSWER:
For greater control over database security, database password management is controlled by database administrators with profiles. The available password management features: Account locking •Enables automatic locking of an account when a user fails to log into the system in the specified number of attempts Password aging and expiration •Enables the password to have a lifetime, after which it expires and must be changed Password history •Checks the new password to ensure that the password is not reused for a specified amount of time or a specified number of password changes . Password complexity verification •Makes a complexity check on the password to verify that it is complex enough to provide protection against intruders who might try to break into the system by guessing the password . Enabling Password Management •Set up password management by using profiles and assign them to users. •Lock, unlock, and expire accounts using the CREATE USER or ALTER USER command.
You've reached the end of your free preview.
Want to read all 17 pages?
- Spring '16
- administrator, Foreign key, Constraint, resource limits