proc_role

Returns information about whether the user has been granted a specified role.

Note: SAP recommends that you use has_role instead of proc_role. You need not, however, convert your existing uses of proc_role to has_role.

Syntax

proc_role("role_name")

Example 1 – Creates a procedure to check if the user is a system administrator:

create procedure sa_check as 
if (proc_role("sa_role") > 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 proc_role("sso_role")
```
Example 3 – Checks that the user has been granted the operator role:
```
select proc_role("oper_role")
```

Using proc_role with a procedure that starts with “sp_” returns an error.
proc_role, a system function, checks whether an invoking user has been granted, and has activated, the specified role.
proc_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
proc_role returns 1 if the invoking user has been granted, and has activated, the specified role.
proc_role returns 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 proc_role.