Skip to main content

SQL Security

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

Get acquainted

images/page_book.pngSQL users, roles, and privileges

Read all about it

images/page_book.pngGRANT (Gives users privileges or roles)

images/page_book.png%CHECKPRIV (Checks if users have privileges or roles)

images/page_book.pngREVOKE (Revokes privileges or roles)

images/page_book.pngCREATE ROLE (Creates a named set of privileges)

images/page_book.pngDROP ROLE (Deletes a named set of privileges)

images/page_book.png$username (System variable identifying the current user)

images/page_book.png$roles (System variable listing the current user’s roles)

Explore more

images/page_navpage.pngSQL

images/page_navpage.pngSecurity

images/page_navpage.pngApplication development

images/page_navpage.pngAuthorization

images/page_navpage.pngSecurity for developers