Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have 2 database Servers - Test and Live. We restore the live database back to test periodically. We have noticed that a SQL User has access to execute a stored proc on live but not on the test database but we can't work out why there is a difference. (Note: The user should be able to execute the stored proc).

We have looked in the users properties and they are all in the same groups, the groups look to be the same on both servers. However when I look at the Effective Permissions on a particular stored proc the user has permission to EXECUTE on live but not on Test:

SQL Permissions

(Live on the left)

How can I find out what is giving access for this user to have permission to Execute on Live?

share|improve this question
    
Found this query which gives me some more clues: SELECT * FROM fn_my_permissions(NULL, 'DATABASE'); Found it here: mssqltips.com/sqlservertip/1440/… –  Greg Oct 14 '13 at 2:14
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.