What are Users and Grants?

Users and grants are SQL's permissions system. A database administrator creates users and grants them permissions to do certain actions, like read or write to tables.

How to use Users and Grants

As an administrator user, you create users and roles using CREATE USER and CREATE ROLE statements. You grant permissions to users using GRANT statements. You can grant privileges to specific users but this is generally not advised. It is better to grant privileges to roles and then assign users roles using GRANT statements.

Difference between Postgres Users & Grants and Doltgres Users & Grants

The goal is for Doltgres users and grants to match Doltgres users and grants exactly. This functionality is not yet implemented, and Doltgres has a single user and password. Submit an issue if you need more functionality.

Last updated