Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-14 : 11:02:43
|
| Diem writes "To Whom It May Concern:I'm building a DB for a Website that allows the users(known as USER and ADMIN) to search from the front end (WebPage); however, since our organization has different types of machines, I can't register everyone to the database through Windows NT. I'm being asked to create one username & password, and one adminname & password. The user is entitled to readonly, while admin is entitled to all the privileges such as CREATE, DELETE, UPDATE, EDIT the record through the front end (which is the Webpage).My questions are as followed:1) How can I link the username & password to the database which has the table using SQL queries?2) How do I make sure that my queries work once I created them?Thank you for your help.Best Regards,Diem" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-14 : 11:57:29
|
| Create the LOGIN in Enterprise Manager, then give it access to the database you want it to have access to. You can modify the permissions that it has under the users folder (Which is under the database).You can test your queries in Query Analyzer.You should make sure your server is installed with mixed security first.-Chad |
 |
|
|
|
|
|
UserValidLogon