OS_ROLES

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.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘OS_ROLES’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
os_roles	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	retrieve roles from the operating system

Oracle initializatoin parameters