Re: dbuser acess privileges

2019-04-04 Thread Tom Lane
Durgamahesh Manne writes: > On Thu, Apr 4, 2019 at 5:55 PM Patrick FICHE > wrote: >> If I’m not wrong, UPDATE requires SELECT permission as the UPDATE >> statement needs to read the data to be updated. > in 9.3 versionGrant access on update command is worked EVEN I DID NOT > EXECUTE THIS

Re: dbuser acess privileges

2019-04-04 Thread Durgamahesh Manne
*From:* Durgamahesh Manne *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

RE: dbuser acess privileges

2019-04-04 Thread Patrick FICHE
nt: Thursday, April 4, 2019 2:50 PM To: pgsql-general@lists.postgresql.org Subject: Re: dbuser acess privileges 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, UPDAT

Re: dbuser acess privileges

2019-04-04 Thread Ron
sql-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'

RE: dbuser acess privileges

2019-04-04 Thread Patrick FICHE
-03_AQSA_Main_Corporate_Logo_JPEG_White_Low.jpg]<http://www.aqsacom.com/> From: Durgamahesh Manne 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 c

Re: dbuser acess privileges

2019-04-04 Thread Durgamahesh Manne
On Thu, Apr 4, 2019 at 4:14 PM Durgamahesh Manne wrote: > > > > On Thu, Apr 4, 2019 at 3:55 PM Ron wrote: > >> On 4/4/19 5:07 AM, Durgamahesh Manne wrote: >> > hi >> > Respected international pgsql team >> > >> > pershing=# grant INSERT on public.hyd to ravi; >> > GRANT >> > i have granted inser

Re: dbuser acess privileges

2019-04-04 Thread Durgamahesh Manne
On Thu, Apr 4, 2019 at 3:55 PM Ron wrote: > On 4/4/19 5:07 AM, Durgamahesh Manne wrote: > > 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

Re: dbuser acess privileges

2019-04-04 Thread Ron
On 4/4/19 5:07 AM, Durgamahesh Manne wrote: 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=#

dbuser acess privileges

2019-04-04 Thread Durgamahesh Manne
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 h