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")

Parameters

Examples

Usage

  • 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.

See also:
  • alter role, create role, drop role, grant, revoke, set in Reference Manual: Commands

  • Transact-SQL Users Guide

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute proc_role.

Related reference
mut_excl_roles
role_contain
role_id
role_name
show_role