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

Purpose of this instance: Draft documentation
DocReleaseID: IRIS2025.1
Content loaded from:
/staging/learning/iris-doc/2025.1.x/doc/cache/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/ensemble/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/security/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/iris/en-us/src/
Excluded items: EAST, EDICOM, EHL72, EHL7T, HXHCINST, HXHCRN, HXIHINST, HXIHRN, PAGE_healthcare
FeedbackOpens in a new tab