Re: WebDB Users and row-level permissions

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 Tue Feb 22 2000 - 13:59:24 CST