> For the complete documentation index, see [llms.txt](https://docs.arkannis.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.arkannis.net/database/general-sql/user-rights.md).

# User rights

Below are different types of syntaxes to grant user rights

```sql
CREATE USER <USERNAME> with PASSWORD '<PASSWORD>';

GRANT SELECT ON ALL TABLES in SCHEMA <SCHEMA_NAME> to <USERNAME>;
-- User rights:

GRANT CONNECT ON DATABASE <DATABSE> TO <USER>;
GRANT USAGE ON SCHEMA <SCHEMA> TO <USER>;
GRANT SELECT ON ALL TABLES IN SCHEMA <SCHEMA> TO <USER>;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA <SCHEMA> TO <USER>;
COMMIT;
```