Search Postgresql Archives

Re: dbuser acess privileges

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You'd think the implicit SELECT perm of that table for the explicit use of UPDATE would be covered by GRANT UPDATE.

On 4/4/19 7:25 AM, Patrick FICHE 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

 

From: Durgamahesh Manne <maheshpostgres9@xxxxxxxxx>
Sent: Thursday, April 4, 2019 12:07 PM
To: pgsql-general@xxxxxxxxxxxxxxxxxxxx
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

 

 

 


--
Angular momentum makes the world go 'round.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux