Re: Restricted query

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
>
>
>