SQL statements for managing RCAC rules

Using the following SQL statements, you can create, alter, and drop RCAC rules.

CREATE PERMISSION

ALTER PERMISSION

CREATE MASK

ALTER MASK

DROP

GRANT (database authorities)

REVOKE (database authorities)

AUDIT

COMMENT

CREATE TABLE

ALTER TABLE

RENAME

CREATE FUNCTION (external scalar)

CREATE FUNCTION (external table)

CREATE FUNCTION (OLE DB external table)

CREATE FUNCTION (SQL scalar, table, or row)

CREATE FUNCTION (sourced or template)

ALTER FUNCTION

CREATE TRIGGER

ALTER TRIGGER