Re: WebDB Users and row-level permissions

[Quoted] 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 [Quoted] 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 [Quoted] on that view based on the WebDb ID ...

The instructor would have full access to the table, the students only thru the view

hth,

[Quoted] 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 Tue Feb 22 2000 - 20:59:24 CET