/
drop_user_from_role
drop_user_from_role
The drop_user_from_role operator lets you remove a user from one or more roles. Available only in the Enterprise Edition.
SciDB security mode must be correctly configured before this or any security operator can be used. See the /wiki/spaces/SD/pages/242909404 section of the /wiki/spaces/SD/pages/241041535.
Synopsis
drop_user_from_role('userName', 'roleName1' [, 'roleName2' ...] )
Summary
- The drop_user_from_role operator lets you revoke roles for a given user.
- Requires operator privilege.
- All parameters are string literals.
Example
$ iquery --auth-file <scidbadmin_login_authentication_file> -a AFL% create_user('John', 'john_password'); -- You can't log in as this user, since 'john_password' is not a valid hash. AFL% create_role('Engineering'); -- Create a new role called Engineering AFL% create_role('Sales'); -- Create a new role called Sales AFL% add_user_to_role('John', 'Engineering', 'Sales'); -- Add John to both Engineering and Sales transactionally AFL% show_roles_for_user('John'); -- Show John's roles. A user always belongs to a role with the same name as the user. {No} role,id {0} 'John',1431 {1} 'Engineering',1432 {2} 'Sales',1433 AFL% drop_role_for_user('John', 'Engineering', 'Sales'); -- Remove John's roles AFL% drop_role('Engineering'); -- Remove the Engineering role AFL% drop_role('Sales'); -- Remove the Sales role AFL% drop_user('John'); -- Remove user John AFL% quit; -- Exit to shell $
, multiple selections available,
Related content
drop_user_from_role
drop_user_from_role
More like this
drop_role
drop_role
More like this
drop_user
drop_user
More like this
add_user_to_role
add_user_to_role
More like this