The show_roles_for_user operator shows the roles assigned to the specified user. Available only in the Enterprise Edition.

SciDB security mode must be correctly configured before this or any security operator can be used. See the Security section of the SciDB Administration Guide.

Synopsis

show_roles_for_user('userName')

Summary

The show_roles_for_user operator shows all the assigned roles of the specified user. The input parameter must be a string literal, enclosed in single quotes. A user can examine her own roles, but operator privilege is required to see the roles of another user.

Example

This example assumes the SciDB database has the following users and role membership (see create_role and add_user_to_role).

User	Roles
Nancy	Nancy, Engineering, Manufacturing, Management

Show the roles that 'Nancy' belongs to:

AFL% show_roles_for_user('Nancy');

The output is:

{No} role,id
{0} 'Nancy',68
{1} 'Engineering',32
{2} 'Manufacturing',35
{3} 'Management',36