Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Grant "create schema" ON database to a user?

Tags:

postgresql

postgresql-9.1

role

I'm using PostgreSQL 9.1 and have to to grant "create schema" ON database to a user.

How can I do that?

like image 807
matheusvmbruno Avatar asked Jun 01 '12 14:06

matheusvmbruno

People also ask

How do I grant privileges to schema?

Only an authorization ID with ACCESSCTRL or SECADM can grant the following privileges on schema names starting with SYS: SELECTIN privilege on SYSCAT, SYSFUN, SYSSTAT or any schema names starting with SYSIBM (SQLSTATE 42501). SELECTIN, CREATEIN and DROPIN privileges on SYSPROC, SYSPUBLIC or SYSTOOLS schemas.

How do I grant a build schema permission in postgresql?

If you want to provide privileges on only a single schema, you will mention the schema's name in the command. >> GRANT USAGE ON SCHEMA public TO Postgres; Now the user can access that particular schema.

Can Db_ddladmin create schema?

db_ddladmin: Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database. As you can see, these permissions will give you privileges to create and manipulate some database structure. However, they will not give you the privileges to alter other user or create schema.

1 Answers

It's more simple than I thought.

GRANT CREATE ON DATABASE db TO user;
like image 180
matheusvmbruno Avatar answered Sep 22 '22 09:09

matheusvmbruno
Sign in to Comment

Related questions

SSL for PostgreSQL connection nodejs
Ruby on Rails: How can I edit database.yml for postgresql?
rake db:create encoding error with postgresql
How to install psycopg2 with pg_config error?
Celery Worker Database Connection Pooling
What is the datatype bytea and when would I use it?
Pyodbc - "Data source name not found, and no default driver specified"
Using INSERT with a PostgreSQL Database using Python
How to visualize database tables in postgresql using pgAdmin?
How many schemas can be created in postgres
Where is psql client history kept? (~/.psql_history non-existent!)
Postgres SSL SYSCALL error: EOF detected with python and psycopg
Using window functions in an update statement
what is @JoinColumn and how it is used in Hibernate
Problem with Postgres ALTER TABLE
Append text to column data based on the column in PostgreSQL
Distinct on Postgresql JSON data column
Postgres FK referencing composite PK
Mixing explicit and implicit joins fails with "There is an entry for table ... but it cannot be referenced from this part of the query"
Slow simple update query on PostgreSQL database with 3 million rows

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!