Re: Restricted query - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Restricted query
Date
Msg-id 40AB8871.7090200@commandprompt.com
Whole thread Raw
In response to Restricted query  (Josué Maldonado <josue@lamundial.hn>)
List 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@postgresql.org)
>>

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Unresponsive vacuum process
Next
From: Ron St-Pierre
Date:
Subject: Re: Function - sequence - cast