I don't want some users be available to create schemas, and only use the public schema.
I'd like to remove the permission of creating schemas, but I can't found anything on PotsgreSQL 9.1 documentation. How can I do this?
I don't want some users be available to create schemas, and only use the public schema. I'd like to remove the permission of creating schemas, but I can't found anything on PotsgreSQL 9.1 documentation. How can I do this? |
|||
|
The documentation of
So let's simply try this. I created a user for this purpose, and if you look at it, it has the
These result in the following behaviour:
So far so good: the user cannot create a new schema. Let's see if it can create objects in the
Hooray! |
|||||||||||
|