inevercheckthis2002 (8/24/2016)
GilaMonster (8/23/2016)
If they're getting denied access to just one table, then there's a object-level permission set on that table. Check the DMVs for the details, you can then use REVOKE to remove that permission.EXEC sp_table_privileges
@table_name='MY_TABLE';
Returns zero rows
Odd, because it should return results. I have a table I just created, no explicit permissions and a user with database owner role running the query and I get this:
Can you check what the user in question has for permissions on the database, schema and table, explicitly what they've been granted or denied. Use a sysadmin user to check that, and query the DMVs.
Also, what fixed database roles does that user have?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
We stand on the bridge and no one may pass