| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | borek(at)lupomesky(dot)cz |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Permission denied when inserting |
| Date: | 2011-02-28 15:31:04 |
| Message-ID: | B59D3D37-B39F-46C4-8E38-9C8CB9127BA0@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Feb 28, 2011, at 8:07 PM, Borek Lupomesky wrote:
> spam=> INSERT INTO permout ( site, cp, owner, descr, creat_who ) VALUES ( 'vin', '3035.1', 'borelupo', 'test', 'borelupo' );
> ERROR: permission denied for relation out2cp
> CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."out2cp" x WHERE "site"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text AND "cp"::pg_catalog.text OPERATOR(pg_catalog.=) $2::pg_catalog.text FOR SHARE OF x"
Try to give SELECT privileges to user on table "public"."out2cp"
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arturo Perez | 2011-02-28 15:37:38 | FTS and words near one another |
| Previous Message | Bill Moran | 2011-02-28 15:29:16 | Re: Permission denied when inserting |