X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D3C7FD1D9E6 for ; Mon, 16 Feb 2004 18:17:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 32797-09 for ; Mon, 16 Feb 2004 14:17:25 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 6CEE9D1DAA0 for ; Mon, 16 Feb 2004 14:17:24 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i1GIHK1a096820 for ; Mon, 16 Feb 2004 18:17:24 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i1GI2ldp094421 for pgsql-admin@postgresql.org; Mon, 16 Feb 2004 18:02:48 GMT From: "Greg Patnude" X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Urgent!!!! Setting permissions on Views Date: Mon, 16 Feb 2004 09:56:49 -0800 Organization: Hub.Org Networking Services Lines: 216 Message-ID: References: <002e01c3f199$6fb52a60$b501a8c0@FI.USJ.EDU.LB> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0061_01C3F473.3238DE70" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/259 X-Sequence-Number: 12433 This is a multi-part message in MIME format. ------=_NextPart_000_0061_01C3F473.3238DE70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable CREATE RULE no_inserts_on_my_view AS ON INSERT TO myView DO INSTEAD NOTHING; --=20 Greg Patnude / The Digital Demention 2916 East Upper Hayden Lake Road Hayden Lake, ID 83835 (208) 762-0762 ""Dani Mezher"" wrote in message news:002e01c= 3f199$6fb52a60$b501a8c0@FI.USJ.EDU.LB... Hello, =20=20=20 I have a small problem setting the permissions for my data. A= ctually my application allows specific users to manipulate selected tuples = stored in the same tables. Therefore, I revoked all privileged on the table= s and encapsulated them through views based on the "user" variable. This wa= y specific users control specific data.=20 =20=20=20 The problem arises when I try to lock my data once it was val= idated. Although I set the permissions on the views to select and revoked t= he insert, update and delete privileges; my users are capable of modifying = the table through the views. I even tried to revoke the select permission b= ut this does not solve the problem. =20=20=20 Can anyone help me fix this problem??? =20=20=20 Regards ------=_NextPart_000_0061_01C3F473.3238DE70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
CREATE RULE no_inserts_on_my_view AS ON IN= SERT TO=20 myView DO INSTEAD NOTHING;
 

--
Greg Patnude / The Digit= al=20 Demention
2916 East Upper Hayden Lake Road
Hayden Lake, ID 83835
(= 208)=20 762-0762
""Dani Mezher"" <dany.mezher@fi.usj.edu.lb&g= t;=20 wrote in message news:002e01c3f= 199$6fb52a60$b501a8c0@FI.USJ.EDU.LB...

Hello,

 

       &nbs= p;   =20 I have a small problem setting the permissions for my data. Actual= ly my=20 application allows specific users to manipulate selected tuples stored in= the=20 same tables. Therefore, I revoked all privileged on the tables and=20 encapsulated them through views based on the =93user=94 variable. This wa= y=20 specific users control specific data.=20

 

       &nbs= p;   =20 The problem arises when I try to lock my data once it was validate= d.=20 Although I set the permissions on the views to select and revoked the ins= ert,=20 update and delete privileges; my users are capable of modifying the table= =20 through the views. I even tried to revoke the select permission but this = does=20 not solve the problem.

 

       &nbs= p;   =20 Can anyone help me fix this problem???

 

Regards

------=_NextPart_000_0061_01C3F473.3238DE70--