Users/Grants
Last updated
Last updated
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.
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.
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. if you need more functionality.