Postgres Pro
Downloads
Home   >   mailing lists

Re: dbuser acess privileges - Mailing list pgsql-general

From Durgamahesh Manne
Subject Re: dbuser acess privileges
Date
Msg-id CAJCZkoKOE2sTMsHZ0622A_G8VXFNgpL0N-DR0=KannDinh5Jpw@mail.gmail.com
Whole thread Raw
In response to RE: dbuser acess privileges  (Patrick FICHE <Patrick.Fiche@aqsacom.com>)
Responses Re: dbuser acess privileges  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

  

From: Durgamahesh Manne <maheshpostgres9@gmail.com> 
Sent: Thursday, April 4, 2019 12:07 PM
To: pgsql-general@lists.postgresql.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




On Thu, Apr 4, 2019 at 5:55 PM Patrick FICHE <Patrick.Fiche@aqsacom.com> wrote:

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

 

 

 


 Hi  Patrick Fiche  as per your info

Grant access on update command is worked  AFTER I DID EXECUTE THIS   GRANT SELECT ON TABLE(hyd)  for non superuser in 10.6

 
But

 in 9.3 version    Grant access on update command is worked  EVEN I DID NOT EXECUTE THIS   GRANT SELECT ON TABLE(hyd)  for non superuser 


Regards

Durgamahesh Manne

Attachment

pgsql-general by date:

Previous
From: Patrick FICHE
Date:
Subject: RE: dbuser acess privileges
Next
From: David Rowley
Date:
Subject: Re: PostgreSQL Windows 2019 support ?