QuestDB LogoQuestDB Logo
Return to QuestDB.comDocumentationTutorialsBlogQuestDB EnterprisePublic SlackDiscourse CommunityView QuestDB Repo
⚡️ QuestDB Enterprise
9.3.3|16.7k
  • Release Notes
  • Roadmap
  • Introduction
  • Schema design
  • Getting Started
  • Ingestion Reference
  • Query & SQL Reference
    • Overview
    • PostgreSQL Wire Protocol
    • REST HTTP API
    • Parquet Export
    • Data Types
    • SQL Syntax
      • ADD USER
      • ALTER
      • ASSUME SERVICE ACCOUNT
      • BACKUP
      • CANCEL QUERY
      • CHECKPOINT
      • COMPILE VIEW
      • COPY
      • CREATE
      • DROP
      • EXIT SERVICE ACCOUNT
      • EXPLAIN
      • GRANT
      • INSERT
      • LOAD PLUGIN
      • REFRESH MATERIALIZED VIEW
      • REINDEX
      • RELOAD PLUGIN
      • REMOVE USER
      • RENAME TABLE
      • REVOKE
      • SELECT
      • SCAN PLUGINS
      • SHOW
      • SNAPSHOT
      • TRUNCATE TABLE
      • UNION EXCEPT INTERSECT
      • UNLOAD PLUGIN
      • UPDATE
      • VACUUM TABLE
    • SQL execution order
    • Functions
    • Operators
  • Concepts
  • Architecture
  • Configuration
  • Security
  • High Availability
  • Operations
  • Deployment
  • Integrations
  • Tutorials & Cookbook
  • Troubleshooting
  • Release Notes
  • Query & SQL Reference
  • SQL Syntax
  • ASSUME SERVICE ACCOUNT

ASSUME SERVICE ACCOUNT reference

Enterprise—

RBAC provides fine-grained database permissions management.

Learn more

ASSUME SERVICE ACCOUNT switches current user to a service account, basically replacing its current access list with the service account's access list.

For full documentation of the Access Control List and Role-based Access Control, see the RBAC operations page.


Syntax​

Flow chart showing the syntax of the ASSUME SERVICE ACCOUNT keyword

Examples​

ASSUME SERVICE ACCOUNT ilp_ingestion;
Edit this page
Previous
ALTER VIEW
Next
BACKUP
  • Syntax
  • Examples

Need a hand? Join our vibrant public Slack and Discourse forum communities.

Copyright © 2026 QuestDB
PrivacyTerms