Check SQL Server Table Permissions

[BillyRogers]

I have an Access program that users outside of our office are using. The
program calls stored procedures (using ADO) in SQL Server from Access. Last
month the program didn't work and I finally tracked it down to the
permissions having been dropped for the group from one of the tables. Our
IT dept never explained to me how this happened, they just reset the
permissions. I'm getting the same problem this month. The stored
procedure uses a lot of tables.

Is there some way to find out which table it is that the permissions are
missing from? Or is there a way to check the persmissions before calling
the stored procedure?

I'm just trying to make this easier to troubleshoot if it happens again.

Thanks,
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

 

[Alex Dybenko]

Hi,
You can just try to run SP or select table and catch error

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com