|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
Profiles in Oracle
Profiles are a means to limit resources a user can use.
Before profiles can be assigned, they must be created with create profile.
Then, they can be assigned to users with alter user ... profile.
The following limits can be specified:
If a session exceeds one of these limits, Oracle will terminate the session. If there is a logoff trigger, it won't be executed.
History of passwords
In order to track password related profile limits, Oracle stores the history of passwords for a user in user_history$.
Quering created profiles
Profiles already created and their settings can be queried through dba_profiles