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 5F1A0D1CA90 for ; Thu, 12 Feb 2004 18:49:16 +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 43607-05 for ; Thu, 12 Feb 2004 14:49:13 -0400 (AST) Received: from fi.usj.edu.lb (fi.usj.edu.lb [212.98.137.194]) by svr1.postgresql.org (Postfix) with ESMTP id E70A1D1B911 for ; Thu, 12 Feb 2004 14:49:10 -0400 (AST) Received: from vent (venus [192.168.3.2]) by fi.usj.edu.lb (8.12.3/8.12.3/Debian-6.4) with ESMTP id i1CK1bUt028260 for ; Thu, 12 Feb 2004 22:01:37 +0200 From: "Dani Mezher" To: Subject: Urgent!!!! Setting permissions on Views Date: Thu, 12 Feb 2004 10:52:59 -0800 Message-ID: <002e01c3f199$6fb52a60$b501a8c0@FI.USJ.EDU.LB> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002F_01C3F156.61945B60" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=BAYES_44, HTML_60_70, HTML_MESSAGE, PLING_PLING X-Spam-Level: X-Archive-Number: 200402/211 X-Sequence-Number: 12385 This is a multi-part message in MIME format. ------=_NextPart_000_002F_01C3F156.61945B60 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hello, I have a small problem setting the permissions for my data. Actually my application allows specific users to manipulate selected tuples stored in the same tables. Therefore, I revoked all privileged on the tables and encapsulated them through views based on the "user" variable. This way specific users control specific data. The problem arises when I try to lock my data once it was validated. Although I set the permissions on the views to select and revoked the insert, update and delete privileges; my users are capable of modifying the table through the views. I even tried to revoke the select permission but this does not solve the problem. Can anyone help me fix this problem??? Regards ------=_NextPart_000_002F_01C3F156.61945B60 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Hello,

 

    =         I have a small problem setting the permissions for my data. Actually my application allows specific users to manipulate selected tuples stored in t= he same tables. Therefore, I revoked all privileged on the tables and encapsul= ated them through views based on the “user” variable. This way speci= fic users control specific data. =

 

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

 

      = ;      Can anyone help me fix this problem???

 

Regards

------=_NextPart_000_002F_01C3F156.61945B60--