February 20, 2002 at 8:14 am
Hi All,
I come accross something today which has somewhat confused me.
We have an access database with linked tables defined. All of the users were able to get to the SQL Server data except one, who kept on getting an error message that the ODBC call had failed and then informed me that the user did not have Select permissions on a table object. What confused me was that she was in the same group as all of the other users who could access the data.
I logged on to her machine using another users domain login and tried connecting with success!
To resolve this, I removed the user from the logins table and added her back in. Now everything is working once again. The details were the same (NT authentication, Domain name, DB Access). Also, when she was logged on, I checked she was on the domain.
Any idea's why this one user did not have permissions until she was dropped and re-added? No users have permissions granted on themselves. Permissions are granted on Roles and users added into Roles on all of our Servers!
As I said, this is now fixed but curious as to what the problem may have been..!
Thanks,
Clive Strong
February 20, 2002 at 9:42 am
If you have correctly troublshot the issue, I wouldn't be surprised if this wasn't a real time check, but rather data stored in a table somewhere. So you add a user and they get a line in the permissions table fro all objects that the role owns.
Is this SQL 6.5? I think this happened to me in v6.5.
Steve Jones
February 20, 2002 at 10:19 am
Without going back to the user account beforehand we will never know. Could have been a mistake was made and revoked here account, thus when you removed and added back it went away.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply