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-01-29 : 17:24:59
|
| Ravi writes "Hi,We are trying to use Application role in Sql server 7.x to deny ad hoc query from Excel/Access/etc.. , we should be able to access only through our application.We read many articles about Application role but none of them gave a simple example of doing this in stright forward steps.Every article we referred simply said we could deny connection from Excel/Access but none really contained a sample simulation to do this.Question:Please provide a simulation for Application role implementation which prevents any sort of connections from MS Excel/MS Access to a sample database.orProivde a link which contains one simulation sample with info.It would be great if it is with screen shots.hope any one who answers this understands what every one expects about Application roles in Sql Server 7.x/2K.byeRavi." |
|
|
|
|
|
Application Role implementation help