SQL Based on Login

[Frank Py]

I would like to construct a custom DB editor / viewer as an ASP novice.
One of the requirements is to be able to show only the records that
apply to a given user. Can anyone point me to some sample code that
might explain how to use session variables that would Select * From
MyTable Where UserID = "THJ456" sort of thing. Help appreciated.

Thanks
Frank

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Chris Hohmann]

Datebase? Version?

In MS SQL Server you could create a view of the table in question based
on the user's id. Then remove revoke access to the table and grant
access to the view.

HTH
-Chris

"Frank Py" <fpy@proactnet.com> wrote in message
news:%23TRi5CXQDHA.2320@TK2MSFTNGP12.phx.gbl...

> I would like to construct a custom DB editor / viewer as an ASP

novice.

> One of the requirements is to be able to show only the records that
> apply to a given user. Can anyone point me to some sample code that
> might explain how to use session variables that would Select * From
> MyTable Where UserID = "THJ456" sort of thing. Help appreciated.
>
> Thanks
> Frank
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!