SV: WebDB Users and row-level permissions

Views are the answer to this questions. Either thru a column holding the USERNAME or via a join to a table linking any id to a USERNAME. /Kjetil

TurkBear <johng_at_mm.com> skrev i
diskussionsgruppsmeddelandet:38b2e992.6707925_at_204.181.81.99...
>
> One way would be to have a parameter in the report that sets the selection
> criteria based on the users student Id ( obtained from another table )
sort of
> like this...
>
> Select grade from grade_report where student id = (select student_id from
> stud_table where student_key = WebdbLoginName )
>
> [ as to how to code this in a WebDb report, I don't have enough working
> knowledge to say...)
>
> You could also set up separate views for the report and grant select
permissions
> on that view based on the WebDb ID ...
>
> The instructor would have full access to the table, the students only thru
the
> view
>
> hth,
>
>
> jacquieNOSPAM_at_softtracks.com (Jacquie Adam) wrote:
>
> >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.
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Wed Feb 23 2000 - 23:07:01 CET