Can't grant select to user x in SQL Server 2005

[RRinTetons]

In SQL Server 2000 I just executed

GRANT SELECT ON TheTable TO TheUser

and there never seemed to be a problem. I just migrated my main db to 2005 and needed to give that access to TheUser.



I did just as I had always done in 2000, and when I start up SSMS and check the Secureables tab for TheUser in TheDatabase is shows the Select permission explicitly granted.


When I try to run a simple select query against TheTable under TheUser's log in I get an access denied error

-----------------------------------------------------
Error:The SELECT permission was denied on the object 'TheTable', database 'TheDatabase', schema 'dbo'. Number:229 Severity:14 State:5
------------------------------------------------------

Is there a change of some sort I missed?

-
Richard Ray
Jackson Hole Mountain Resort

 

[RRinTetons]

In the spirit of 'If at first you don't succeed, try something else' I added a completely new user directly to the 2005 DB and gave the user what swear are the exact same permissions as the old one that migrated. The only difference is that the new one works, and the old one still doesn't.

Is there a general audit query I could use to line the two log in's up against each other and see where they differ? Browsing throught them in SSMS doesn't reveal anything that I can see.

-
Richard Ray
Jackson Hole Mountain Resort