SQL Security

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

Get acquainted

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)

Application development