RE: dbuser acess privileges

From: Patrick FICHE <Patrick(dot)Fiche(at)aqsacom(dot)com>
To: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: dbuser acess privileges
Date: 2019-04-04 12:25:22
Message-ID: VI1PR0501MB2574023F98327C987C2346C1EF500@VI1PR0501MB2574.eurprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

If I’m not wrong, UPDATE requires SELECT permission as the UPDATE statement needs to read the data to be updated.
So, you should probably add GRANT SELECT and you get it work.

Regards,

Patrick Fiche
Database Engineer, Aqsacom Sas.
c. 33 6 82 80 69 96

[01-03_AQSA_Main_Corporate_Logo_JPEG_White_Low.jpg]<http://www.aqsacom.com/>

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
Sent: Thursday, April 4, 2019 12:07 PM
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: dbuser acess privileges

hi

Respected international pgsql team

pershing=# grant INSERT on public.hyd to ravi;
GRANT
i have granted insert command access to non superuser(ravi)
pershing=> insert into hyd (id,name) values('2','delhi');
INSERT 0 1
here data inserted

pershing=# grant UPDATE on public.hyd to ravi;
GRANT
i have granted update command access to non superuser(ravi)

pershing=> update public.hyd set id = 3 where name = 'hyderabad';
ERROR: permission denied for relation hyd
please let me know what is the issue with update command

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-04-04 12:49:48 Re: dbuser acess privileges
Previous Message Durgamahesh Manne 2019-04-04 11:46:01 Re: dbuser acess privileges