REVOKE
Synopsis
-- Entity access (full -- removes entire rule)
REVOKE module.Role ON module.Entity
-- Entity access (partial -- downgrades specific rights)
REVOKE module.Role ON module.Entity ( rights )
-- Microflow access
REVOKE EXECUTE ON MICROFLOW module.Name FROM module.Role [, ...]
-- Page access
REVOKE VIEW ON PAGE module.Name FROM module.Role [, ...]
-- Nanoflow access
REVOKE EXECUTE ON NANOFLOW module.Name FROM module.Role [, ...]
Description
Removes previously granted access rights from module roles. Each form is the counterpart to the corresponding GRANT statement.
Entity Access
Without a rights list, removes the entire entity access rule for the specified module role on the entity.
With a rights list, performs a partial revoke: REVOKE READ (x) sets member x to no access. REVOKE WRITE (x) downgrades member x from ReadWrite to ReadOnly. REVOKE CREATE and REVOKE DELETE remove the structural permission. The access rule itself is preserved.
Microflow Access
Removes execute permission on a microflow from one or more module roles.
Page Access
Removes view permission on a page from one or more module roles.
Nanoflow Access
Removes execute permission on a nanoflow from one or more module roles.
Parameters
module.Role- The module role losing access. Must be a qualified name (
Module.RoleName). module.Entity- The entity whose access rule is removed or modified.
rights- Optional. A comma-separated list of rights to revoke (partial revoke). Same syntax as GRANT rights:
CREATE– revoke create permissionDELETE– revoke delete permissionREAD *– revoke all read accessREAD (Attr1, ...)– revoke read on specific attributesWRITE *– downgrade all members from ReadWrite to ReadOnlyWRITE (Attr1, ...)– downgrade specific attributes from ReadWrite to ReadOnly
module.Name- The target microflow, nanoflow, or page.
FROM module.Role [, ...]- One or more module roles losing access (for microflow, page, and nanoflow forms).
Examples
Remove all entity access for a role:
REVOKE Shop.Viewer ON Shop.Customer;
Partial revoke – remove read access on a specific attribute:
REVOKE Shop.User ON Shop.Customer (READ (Notes));
Partial revoke – downgrade write to read-only:
REVOKE Shop.User ON Shop.Customer (WRITE (Email));
Partial revoke – remove structural permission:
REVOKE Shop.User ON Shop.Customer (DELETE);
Remove microflow execution from multiple roles:
REVOKE EXECUTE ON MICROFLOW Shop.ACT_Order_Process FROM Shop.Viewer;
Remove page visibility:
REVOKE VIEW ON PAGE Shop.Admin_Dashboard FROM Shop.User;
Remove nanoflow execution:
REVOKE EXECUTE ON NANOFLOW Shop.NAV_ValidateInput FROM Shop.Viewer;