Re: WebDB Users and row-level permissions

From: Leo Van Nieuwenhuyse <leo.van.nieuwenhuyse_at_pandora.be>
Date: Mon, 28 Feb 2000 20:31:06 GMT
Message-ID: <eWAu4.48596$2v4.123942@afrodite.telenet-ops.be>

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.
>
Received on Mon Feb 28 2000 - 14:31:06 CST