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 |
|
dknibbs
Starting Member
4 Posts |
 Posted - 2003-03-20 : 06:33:56
|
| I have an application that uses an application role with a password to authenticate users. The role has been granted full access to all of the objects it needs and yet I occassionally get a permission denied. I suspect on of the controls I am using is doing something strange but in order to test this I need to be able to tell how the user was authenticated. Is there a way that I can tell which role authenticated the user i.e Application or database role. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-03-20 : 10:57:35
|
| No miracles....How does the application login to the database? Are you using connection pooling? Do you use a trusted connection or SQL Server security. Do users login with their own sql server ids?A little more info would be helpful.Brett8-) |
 |
|
|
dknibbs
Starting Member
4 Posts |
Posted - 2003-03-20 : 11:27:56
|
| The application role is set during the initialisation of the VB app using setapprole. Most users additionally have access to certain objects using normal NT authentication. The application role has access to ALL objects but the other roles have various levels of access.There is no connection pooling, just a straightforward ODBC connection from VB app direct to SQL Server. |
|
|
|
|
|
|
Application Authentication