Returns information about whether the user has been granted a specified role.
Sybase supports—and recommends—that
you use has_role instead of proc_role.
You need not, however, convert your existing uses of proc_role to has_role.
proc_role("role_name")
is the name of a system or user-defined role.
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
Checks that the user has been granted the System Security Officer role:
select proc_role("sso_role")
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.
Commands alter role, create role, drop role, grant, set, revoke
Documentation Transact-SQL Users Guide
Functions mut_excl_roles, role_contain, role_id, role_name, show_role
