I am very new to SQL. I am designing a website using Frontpage 2002 and
Microsoft SQL 2000. I have the databse all set up and am able to access the
data from the database using the ASP pages I have created.
The website runs on IIS 5.0 and I am using NTFS authentication with Client
Certificates. I have a database called call_log and this is where all my
salesman enter in their customer call activity.
What I want to happen is when Joe loggs into the website and goes to view
the call_log ASP page, he only sees the call logs that Joe has entered and
not the entire database.
I have been able to accomplish this by creating a seperate page for each
salesman and then having them select their name from a menu to get to this
page. What I would really like to happen is for the database to know whose
call logs to return depending on the userename that is logged in.
I do not know if I am totally way off base in thinking that this can be
done, but it seems to me it should be able to be done with some sort of
permissions. If anyone could give me a few pointers I would appreciate it.
Thanks!
Microsoft SQL 2000. I have the databse all set up and am able to access the
data from the database using the ASP pages I have created.
The website runs on IIS 5.0 and I am using NTFS authentication with Client
Certificates. I have a database called call_log and this is where all my
salesman enter in their customer call activity.
What I want to happen is when Joe loggs into the website and goes to view
the call_log ASP page, he only sees the call logs that Joe has entered and
not the entire database.
I have been able to accomplish this by creating a seperate page for each
salesman and then having them select their name from a menu to get to this
page. What I would really like to happen is for the database to know whose
call logs to return depending on the userename that is logged in.
I do not know if I am totally way off base in thinking that this can be
done, but it seems to me it should be able to be done with some sort of
permissions. If anyone could give me a few pointers I would appreciate it.
Thanks!