Just View create privilege to user user2

From: M Sarwar <sarwarmd02(at)outlook(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Just View create privilege to user user2
Date: 2023-05-03 23:07:43
Message-ID: DM4PR19MB5978ABDF877412086889CC50D36C9@DM4PR19MB5978.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2023-05-03 23:28:51 Re: Just View create privilege to user user2
Previous Message Sergey Cherevko 2023-05-03 13:55:18 unknown postgres ssl error "could not accept SSL connection: Success" and timeout