SQL Security
InterSystems IRIS® supports a rich set of security tasks in SQL.
Get acquainted
Read all about it
GRANT (Gives users privileges or roles)
%CHECKPRIV (Checks if users have privileges or roles)
REVOKE (Revokes privileges or roles)
CREATE ROLE (Creates a named set of privileges)
DROP ROLE (Deletes a named set of privileges)
$username (System variable identifying the current user)
$roles (System variable listing the current user’s roles)