Skip to main content

SQL Security

HealthShare® Health Connect supports a rich set of security tasks in SQL.

Get acquainted

documentation iconSQL users, roles, and privileges

Read all about it

documentation iconGRANT (Gives users privileges or roles)

documentation icon%CHECKPRIV (Checks if users have privileges or roles)

documentation iconREVOKE (Revokes privileges or roles)

documentation iconCREATE ROLE (Creates a named set of privileges)

documentation iconDROP ROLE (Deletes a named set of privileges)

documentation icon$username (System variable identifying the current user)

documentation icon$roles (System variable listing the current user’s roles)

Explore more

Navigation iconSQL

Navigation iconSecurity

Navigation iconApplication development

Navigation iconAuthorization

Navigation iconSecurity for developers