The show_users_in_role operator shows the users in the specified role. 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_users_in_role('roleName')

Summary

The show_users_in_role operator shows all the members of the specified role. The input parameter must be a string literal, enclosed in single quotes. Operator privilege is required.

Example

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

User	Roles
Mary	Mary, Engineering, Management
Elizabeth	Elizabeth, Manufacturing
John	John, Engineering
Susan	Susan, Manufacturing, Management
Nancy	Nancy, Engineering, Manufacturing, Management

Show the users in the 'Manufacturing' Role:

AFL% show_users_in_role('Manufacturing');

The output is:

{No} user
{0} 'Elizabeth'
{1} 'Susan'
{2} 'Nancy'