Manage Passwords Using Profiles
Profiles are named sets of passwords and resource limits. They are assigned to individual users using the CREATE USER or ALTER USER command and can be enabled or disabled. Every database comes with at least one profile, the DEFAULT profile. With a profile, you can do the following:
Set rules for password aging and expiration.
Maintain password history so that you can manage reuse.
Set rules for password complexity and verification.
Set rules for account locking.
Set limits on CPU time and I/O operations.
Set limits on allowable idle time.
Set limits on allowable connect time.
Set limits on allowable concurrent sessions.
After a profile is created, the DBA assigns users to that profile. If resource limits are used, Oracle ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
