GrantPrivilege

Synopsis

[Actions]
GrantPrivilege:ObjPriv=a,ObjList=b,Type=c,User=d,Namespace=e,WithGrant=f

Where a is a comma delimited string of actions to grant or * for all actions.

Where b is a comma delimited list of SQL object names or * for all objects.

Where c is Table, View, Schema, Stored Procedures, or ML Configuration.

Where d is a comma delimited list of users.

Where e is the desired Namespace.

Where f is 0/1 for the WITH GRANT OPTION.

Description

GrantPrivilege lets you grant an object privilege to users via this call instead of using the SQL GRANT statement. This can include grant privileges. InterSystems IRIS® grants the privileges when processing the [Actions] section during a configuration merge. During the merge, InterSystems IRIS changes to the provided namespace and runs %SYSTEM.SQL.Security.GrantPrivilege()Opens in a new tab (if WithGrant=0) or %SYSTEM.SQL.Security.GrantPrivilegeWithGrant()Opens in a new tab (if WithGrant=1) to grant the object privileges defined by GrantPrivilege.

Changing this Operation

This operation is designed to be used during a configuration merge. You can change GrantPrivilege by editing the merge file in a text editor (as described in Editing the Active CPF).

See GRANT (SQL) for information on the SQL command.