public inbox for [email protected]
help / color / mirror / Atom feedHow to grant only create schemas and create database objects permission to user.
2+ messages / 2 participants
[nested] [flat]
* How to grant only create schemas and create database objects permission to user.
@ 2017-07-19 12:23 Dinesh Chandra 12108 <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Dinesh Chandra 12108 @ 2017-07-19 12:23 UTC (permalink / raw)
To: [email protected] <[email protected]>; +Cc: pgsql-performance
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?
Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.
------------------------------------------------------------------
Mobile: +91-9953975849 | Ext 1078 |[email protected]<mailto:%[email protected]>
Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
________________________________
DISCLAIMER:
This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Check all attachments for viruses before opening them. All views or opinions presented in this e-mail are those of the author and may not reflect the opinion of Cyient or those of our affiliates.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to grant only create schemas and create database objects permission to user.
@ 2017-07-19 13:43 vinny <[email protected]>
parent: Dinesh Chandra 12108 <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: vinny @ 2017-07-19 13:43 UTC (permalink / raw)
To: Dinesh Chandra 12108 <[email protected]>; +Cc: [email protected]; pgsql-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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-07-19 13:43 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-07-19 12:23 How to grant only create schemas and create database objects permission to user. Dinesh Chandra 12108 <[email protected]>
2017-07-19 13:43 ` vinny <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox