Re: WebDB Users and row-level permissions

Leo Van Nieuwenhuyse wrote:
>
> We do a lot of such restrictions in Webdb:
>
> Just put your condition in a view and build your applications on views.
>
> Jacquie Adam <jacquieNOSPAM_at_softtracks.com> schreef in berichtnieuws
> 38b2dac6_at_rsl2.rslnet.net...
> > I have a question regarding row-level security for WebDB report users.
> >
> > For example, in a University the professor goes in and enters grades for
> > everybody. The student can then log in to the WebDB site and view a
 report
> > that only shows his or her grades. I'm guessing the WebDB username has to
 be
> > somehow mapped to the proper studentid. I know this can be done, but HOW
 would
> > it be implemented?
> >
> > StudentID Grade
> > --------- -----
> > 12345 84%
> > 97352 67%
> >
> >
> > WebDB USERS: (Not currently in a table in my database)
> >
> > Userid Password
> > -------- --------
> > KenJones f39f3 <--- student 12345
> > TomWhite 9fjm3 <----student 97352
> >
> >
> > Any pointers greatly appreciated.
> > Thanks,
> > Jacquie.
> >

8i also supports 'fine grained' security access via the DBMS_RLS package...

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse