pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Urgent!!!! Setting permissions on Views
3+ messages / 3 participants
[nested] [flat]

* Urgent!!!! Setting permissions on Views
@ 2004-02-12 18:52 Dani Mezher <dany.mezher@fi.usj.edu.lb>
  2004-02-15 05:46 ` Re: Urgent!!!! Setting permissions on Views Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-16 17:56 ` Re: Urgent!!!! Setting permissions on Views Greg Patnude <gpatnude@hotmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Dani Mezher @ 2004-02-12 18:52 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Urgent!!!! Setting permissions on Views
  2004-02-12 18:52 Urgent!!!! Setting permissions on Views Dani Mezher <dany.mezher@fi.usj.edu.lb>
@ 2004-02-15 05:46 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-02-15 05:46 UTC (permalink / raw)
  To: Dani Mezher <dany.mezher@fi.usj.edu.lb>; +Cc: pgsql-admin

"Dani Mezher" <dany.mezher@fi.usj.edu.lb> writes:
>             I have a small problem setting the permissions for my data.

What PG version is this?  There's a known bug in some recent versions
about checking view permissions ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Urgent!!!! Setting permissions on Views
  2004-02-12 18:52 Urgent!!!! Setting permissions on Views Dani Mezher <dany.mezher@fi.usj.edu.lb>
@ 2004-02-16 17:56 ` Greg Patnude <gpatnude@hotmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Greg Patnude @ 2004-02-16 17:56 UTC (permalink / raw)
  To: pgsql-admin

CREATE RULE no_inserts_on_my_view AS ON INSERT TO myView DO INSTEAD NOTHING;


-- 
Greg Patnude / The Digital Demention
2916 East Upper Hayden Lake Road
Hayden Lake, ID 83835
(208) 762-0762

  ""Dani Mezher"" <dany.mezher@fi.usj.edu.lb> wrote in message news:002e01c3f199$6fb52a60$b501a8c0@FI.USJ.EDU.LB...
  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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-02-16 17:56 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-12 18:52 Urgent!!!! Setting permissions on Views Dani Mezher <dany.mezher@fi.usj.edu.lb>
2004-02-15 05:46 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-02-16 17:56 ` Greg Patnude <gpatnude@hotmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox