SQL Security

SQL users, roles, and privileges

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)

SQL

Security

Application development

Authorization