Docs

RDS for PostgreSQL

FAQs

Account privileges

Account privileges

This topic summarizes frequently asked questions about RDS for PostgreSQL account permissions.

What are the differences between a super account and a normal account?

Super account: You can create multiple. A super account can manage all normal accounts and databases.

Normal account: You can create multiple. You need to manually grant specific database permissions to a normal account.

tip

For specific information on account privileges, refer to Creating an account.

Can I modify a specific permission of a super account?

The super account can only be reset to the initial status, not modified to specific permissions.

tip

For specific information on account privileges, refer to Creating an account.

Can a database be associated with multiple accounts?

You can associate only one account to a database.

How to grant privileges for a single schema?

The Console only supports global‑level privilege grants. If you want to grant privileges on a single schema, you need to use SQL statements. For example, to grant user the permission to use demo_schema, execute the statement GRANT USAGE ON SCHEMA demo_schema TO user;.

Will the table owner be updated synchronously after the Schema owner is modified via the Console?

No. Modifying the owner of a schema does not synchronously update the owners of tables within that schema. To modify table owners, SQL statements are required for separate updates. For example: ALTER TABLE table_name OWNER TO new_owner;.

Last updated: 2026.08.20 17:11:35