|
Category: ASE: Functions: User, Login and Role Functions
show_role()
The
role function
show_role()
returns the active
roles
for the current
session.
Syntax of the Role Function show_role()
Example for the Role Function show_role()
select show_role()
go
-----
sa_role sso_role oper_role sybase_ts_role replication_role mon_role
Returns all active roles for the current session for user "sa".
See also:
alter role,
create role,
drop role,
grant role,
revoke role,
set role,
has_role(),
proc_role(),
mut_excl_roles(),
role_contain(),
role_id(),
role_name(),
sp_activeroles,
sp_displayroles,
sp_role,
suser_id(),
suser_name(),
user,
user_id(),
user_name(),
valid_user()
and
Functions.
See also:
ASE T-SQL - Aggregate Functions,
ASE T-SQL - User,
mut_excl_roles(),
proc_role(),
role_contain(),
role_id(),
role_name(),
suser_id(),
suser_name(),
user,
user_id(),
user_name(),
valid_name(),
valid_user().
|
