The
security functions return information about security services and
user-defined roles. Table 15-15 lists the name of each security function,
the argument it takes, and the result it returns.
Table 15-15: Security functions
Function
|
Argument
|
Result
|
|---|
audit_event_name
|
(event_id)
|
Returns a description of an audit event.
|
is_sec_service_on
|
(security_service_nm)
|
Determines whether a particular security
service is enabled. Returns 1 if the service is enabled; otherwise,
returns 0.
|
mut_excl_roles
|
(“role_1” , “role_2” [,
"membership" |"activation"])
|
Returns information about the level of
mutual exclusivity between two roles.
|
proc_role
|
(“role_name” )
|
Returns 0 if the invoking user does not
possess or has not activated the specified role; 1 if the invoking
user has activated the specified role; and 2 if the user possesses
the specified role directly or indirectly, but has not activated
the role.
|
role_contain
|
(["role1 ",
"role2 "])
|
Returns 1 if the first role specified
is contained by the second.
|
role_id
|
(“role_name”)
|
Returns the role ID of the specified
role name.
|
role_name
|
(role_id )
|
Returns the role name of the specified
role ID.
|
show_role
|
( )
|
Returns the login’s current
active roles, if any (sa_role, sso_role, oper_role, replication_role,
or role_name). If the login has no
roles, returns NULL.
|
show_sec_services
|
( )
|
Returns a list of the available security
services that are enabled for the current session.
|
