has_role

Returns information about whether an invoking user has been granted, and has activated, the specified role.

Syntax

has_role ("role_name", option)

role_name – is the name of a system or user-defined role.
option – allows you to limit the scope of the information returned. Currently, the only option supported is 1, which suppresses auditing.

Example 1 – Creates a procedure to check if the user is a System Administrator:

create procedure sa_check as 
if (has_role("sa_role", 0) > 0) 
begin 
    print "You are a System Administrator." 
    return(1) 
end

Example 2 – Checks that the user has been granted the System Security Officer role:
```
select has_role("sso_role", 1)
```
Example 3 – Checks that the user has been granted the Operator role:
```
select has_role("oper_role", 1)
```

has_role functions the same way proc_role does. In SAP ASE versions 15.0 and later, we recommend that you use has_role instead of proc_role. You need not, hoever, convert all of your existing uses of proc_role to has_role.
has_role returns 0 if the user has:
- Not been granted the specified role
- Not been granted a role which contains the specified role
- Been granted, but has not activated, the specified role
has_role returns:
- 1 – if the invoking user has been granted, and has activated, the specified role.
- 2 – if the invoking user has a currently active role, which contains the specified role.

ANSI SQL – Compliance level: Transact-SQL extension.

Any user can execute has_role.