Skip to main content

SQL Security

InterSystems IRIS® supports a rich set of security tasks in SQL.

Get acquainted

SQL users, roles, and privileges

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)

Explore more

SQL

Security

Application development

Authorization

FeedbackOpens in a new tab