MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Wed, 19 Jul 2017 15:43:55 +0200
From: vinny <vinny@xs4all.nl>
To: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
Cc: pgsql-performance-owner@postgresql.org, pgsql-performance@postgresql.org
Subject: Re: How to grant only create schemas and create database
 objects permission to user.
In-Reply-To: <c7ded1b24d9b48a78fe037f79b3e8802@cyient.com>
References: <c7ded1b24d9b48a78fe037f79b3e8802@cyient.com>
Message-ID: <5ccd93b10b3925df4a3ca2f8ee0ff6fc@xs4all.nl>
User-Agent: XS4ALL Webmail
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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 (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance