Hello,
How can i create a user with admin role?
When i tried
CREATE USER test WITH PASSWORD '*'
show users
user admin
test false
It sets admin as false. What is the command to set the admin value to true?
Thanks,
Shilpa
The syntax for granting privileges is explained on the administration page in the docs.
To add admin privileges to a newly created user, you need to add WITH ALL PRIVILEGES at the end. E.g.
CREATE USER test WITH PASSWORD 'password' WITH ALL PRIVILEGES
The above referenced page no longer exists. Where is the administration page now?
The info is now on this page.
Most helpful comment
The syntax for granting privileges is explained on the administration page in the docs.
To add admin privileges to a newly created user, you need to add
WITH ALL PRIVILEGESat the end. E.g.