public inbox for [email protected]
help / color / mirror / Atom feedFrom: vinny <[email protected]>
To: Dinesh Chandra 12108 <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: How to grant only create schemas and create database objects permission to user.
Date: Wed, 19 Jul 2017 15:43:55 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
On 2017-07-19 14:23, Dinesh Chandra 12108 wrote:
> Dear expert,
>
> I have to create a user which have permission to CREATE SCHEMAS AND
> CREATE DATABASE OBJECTS in database.
>
> I am using postgres 9.1.
>
> Could you please assist me?
Access control is managed using the GRANT command:
https://www.postgresql.org/docs/9.1/static/sql-grant.html
About halfway down that page it says:
-----
CREATE
For databases, allows new schemas to be created within the database.
For schemas, allows new objects to be created within the schema. To
rename an existing object, you must own the object and have this
privilege for the containing schema.
For tablespaces, allows tables, indexes, and temporary files to be
created within the tablespace, and allows databases to be created that
have the tablespace as their default tablespace. (Note that revoking
this privilege will not alter the placement of existing objects.)
----
I suggest you try it out on a test database first.
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: How to grant only create schemas and create database objects permission to user.
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox