ODBC connection

[barbb]

Is there a way to limit an ODBC connection to a specific application? While using our application the user needs read, write, delete, etc. rights to the database. But, I don't want them to have those rights when using another application to access our database. Does anybody know a way to prevent this?

Any help will be greatly appreciated!

barbara

 

[tlbroadbent]

Depends on the database. SQL Server has application roles which allow access to specific applications that invoke them. I don't know about other DBs. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.