REVOKE SQL-GPT Context Permission

Permissions on SQL-GPT contexts that have been granted directly to users or roles can be revoked.

REVOKE SQL-GPT Context Permission Syntax

REVOKE <READ | ADMIN> [PRIVILEGES]
ON <ALL CONTEXTS [IN [SCHEMA] <schema reference>] | CONTEXT <context reference>>
FROM <user name | role name>

REVOKE Create SQL-GPT Context Permission Syntax

REVOKE CREATE [PRIVILEGES] ON CONTEXTS
[IN [SCHEMA] <schema reference>]
FROM <user name | role name>

Examples

To revoke read access on the SQL-GPT context named example.atc_ctx from the ctxuser user:

REVOKE SQL-GPT Context Permission Example

REVOKE READ ON CONTEXT example.atc_ctx FROM ctxuser