| Property | Description |
|---|---|
| Parameter type | Boolean |
| Default value | false |
| Modifiable | No |
| Range of values | true | false |
OS_ROLES determines whether Oracle or the operating system identifies and manages the roles of each username.
Values:
TRUE
The operating system completely manages the role grants for all database usernames. When a user attempts to create a session, the username's security domain is initialized using the roles identified by the operating system. A user can subsequently enable as many roles identified by the operating system as specified by the parameter MAX_ENABLED_ROLES.
Revocation by Oracle of roles granted by the operating system is ignored, as are any roles previously granted by Oracle.
FALSE
Oracle identifies and manages the roles.
See Also:
Oracle Database Administrator's Guide and Oracle Database Advanced Security Administrator's Guide for more information on roles and on setting this parameter