For AI agents: the complete documentation index is at llms.txt. Every page is also available as markdown by appending .md to its URL, or by sending an Accept: text/markdown request header.

ALTER GROUP DROP EXTERNAL ALIAS reference

Enterprise:

RBAC provides fine-grained database permissions management.

Learn moreFree trial

ALTER GROUP ... DROP EXTERNAL ALIAS removes an external OIDC or LDAP group mapping.

Syntax​

ALTER GROUP groupName DROP EXTERNAL ALIAS externalAlias;

Description​

Removing an alias requires the REMOVE EXTERNAL ALIAS permission. Quote the alias when it contains commas, spaces, or =, as LDAP distinguished names do.

Members of the external group stop inheriting this group's permissions on their next login. The QuestDB group itself, and any user explicitly added to it, are unaffected.

Examples​

ALTER GROUP analysts DROP EXTERNAL ALIAS 'CN=Analysts,OU=Users,DC=example,DC=com';

SHOW GROUPS then reports an empty external_alias column for the group.

See also​