From: M Sarwar <sarwarmd02@outlook.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Just View create privilege to user user2
Date: Wed, 3 May 2023 23:07:43 +0000
Message-ID: <DM4PR19MB5978ABDF877412086889CC50D36C9@DM4PR19MB5978.namprd19.prod.outlook.com> (raw)
Hi,
I have 2 users and 2 schemas in my database db1.
Users are u1 and u2.
Schemas are s1 and s2,
User u1 has full ( SELECT, CREATE, UPDATE, etc for tables/indexes/all objects) access from /to s1 schema.
user u2 has all SELECT on all tables of schema s1
I want user u2 to have only CREATE VIEW privilege in schema s2. I do not want u2 to create any other type of objects in s2 schema.
I am unable to find the command to grant just CREATE VIEW privilege to be granted to u2.
I will appreciate anu help on this.
Thanks,
Sarwar
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: pgsql-admin@postgresql.org
Cc: sarwarmd02@outlook.com, pgsql-admin@lists.postgresql.org
Subject: Re: Just View create privilege to user user2
In-Reply-To: <DM4PR19MB5978ABDF877412086889CC50D36C9@DM4PR19MB5978.namprd19.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox