Обсуждение: [PERFORM] How to grant only create schemas and create database objectspermission to user.
[PERFORM] How to grant only create schemas and create database objectspermission to user.
От
Dinesh Chandra 12108
Дата:
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 |dinesh.chandra@cyient.com
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.
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.