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 |
|
ie94mhg
Starting Member
10 Posts |
 Posted - 2001-12-21 : 12:06:35
|
| I need to restrict access to some users to connect to the databse by the tools of SQL Server, just with some application. What can i do to put a restriction in SQL Server 7.0 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-21 : 12:28:45
|
| Are you saying that you want to block some users (e.g. Joe and Mary) from accessing SQL Server ONLY when they use some applications (e.g. Access) but allow them access when they use other applications (e.g. VB or Excel)? Am I reading your question right?-------------------It's a SQL thing... |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2001-12-21 : 12:35:14
|
| Don't give them user accounts, so they will be unable to access the DB individually. Then create an application role for the application to use.-Chad |
|
|
|
|
|
|
Security