Hello,
I want to make a user that has read-only access to a database. I've read
the man pages on grant and revoke for table-level permissions, but I don't
see anything for database-level permissions on, say, creating tables or
views. Suppose I want to deny CREATE to some user. How does postgre
If I understand your question correctly, createuser will do this.
'man createuser'
...
-D Does not allow the user to create databases.
Thomas Dean wrote:
>If I understand your question correctly, createuser will do this.
>
>'man createuser'
>...
> -D Does not allow the user to create databases.
This does not affect the ability to create tables; only databases:
junk=> alter user dan nocreatedb;
ALTER USER