pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUrgent!!!! 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