Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Check SQL Server Table Permissions
1 view
Skip to first unread message
BillyRogers
Nov 13, 2007, 2:32:00 PM11/13/07
to
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.
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
Nov 14, 2007, 11:21:00 AM11/14/07
to
Hi,
You can just try to run SP or select table and catch error
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
"BillyRogers" <Billy...@discussions.microsoft.com> wrote in message
news:7BB4DF4B-0753-437E...@microsoft.com...
0 new messages