From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Marco Lazzeri <marcomail(at)noze(dot)it> |
Cc: | Josué Maldonado <josue(at)lamundial(dot)hn>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Restricted query |
Date: | 2004-05-19 16:16:49 |
Message-ID: | 40AB8871.7090200@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Marco Lazzeri wrote:
> And what about restricting UPDATE/DELETE queries too. Can I still use
> VIEWs?
No but that you could use a function for.
Sincerely,
Joshua D. Drake
>
> Bye
>
> Il mer, 2004-05-19 alle 05:06, Joshua D. Drake ha scritto:
>
>>You could use a view and give group rights to a particular view.
>>
>>Josué Maldonado wrote:
>>
>>
>>>Hello list,
>>>
>>>This is an inventory system where some users are restricted to view only
>>>certain suppliers, those restrictions are in a table called pedusers
>>>(username,supplierallowed), there are other kind of "superuser" who are
>>>not restricted, actually I created another table for them (userexcept).
>>>To select restricted rows I use this code:
>>>
>>>select * from prvdor
>>>where prvtiprov = 2 and
>>>prvpk in
>>>(select usr_prvdor from peduser where
>>>usr_login = 'default')
>>>
>>>
>>>I think I would write this in a return set function instead but I would
>>>like to know others ways to write a SQL sentence to return the rows
>>>according users permission/restrictions.
>>>
>>>
>>>Thanks in advance for your comments
>>>
>>>
>>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2004-05-19 16:41:12 | Re: Does INSERT inserts always at the end ? |
Previous Message | Ed L. | 2004-05-19 15:52:19 | Unresponsive vacuum process |