From: | Marco Lazzeri <marcomail(at)noze(dot)it> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | Josué Maldonado <josue(at)lamundial(dot)hn>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Restricted query |
Date: | 2004-05-19 12:50:11 |
Message-ID: | 1084971010.8240.1.camel@macbeth.intranet.noze.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
And what about restricting UPDATE/DELETE queries too. Can I still use
VIEWs?
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 | Florence HENRY | 2004-05-19 13:19:26 | Does INSERT inserts always at the end ? |
Previous Message | Jerry Sievers | 2004-05-19 12:32:06 | pg_temp_N temp schema buildup |