Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
From: Durgamahesh Manne <maheshpostgres9@gmail.com> Sent: Thursday, April 4, 2019 12:07 PMTo: pgsql-general@lists.postgresql.orgSubject: 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;
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
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 FicheDatabase Engineer, Aqsacom Sas.c. 33 6 82 80 69 96
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
В списке pgsql-general по дате отправления: