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 - 2001-01-16 : 23:09:51
|
Mike writes "Greetings.
This may be off topic as the question isn't really specific to MSSQL but here it goes.
I have a set of applications that users access through terminal services. The application vendor provides something of a "turn key" solution and created the databases with "all" granted to "public". This seems ok as the application itself includes databases where we configure user access to the data, but this model of security only works as long as the user accesses the data via the applications.
Now users are looking for access via ODBC, but I am unable to find an eloquent way (ie simple) to ensure that the security model remains intact. Is there a way to control access without having to overhaul the database permissions via a series of grants and revokes?
I am sure this is a common problem and I hope someone has a better way to deal with it.
Thank you.
Mike" |
|
|
|
|
|
ODBC and security