Stored procedure and GRANT EXECUTE permissions
jdnep
Posts: 5
I am having problems with synchronizing stored procedures. I keep getting a discrepancy on permissions to execute the stored procedure. When I select the item and "synchronize", I then refresh the view and still get a message stating that the stored procedure is still out of synch. I manually check both DB and they both have the same EXECUTE permissions. What is the problem? :?
This discussion has been closed.
Comments
Can i check a couple of things with you.
Firstly the situation is that the permissions needed to be synchronised. They were then synchronised but after a refresh of the project, although they are now the same, both upper and lower views report them as being out of sync.
Secondly could you let me know what version of the products you have installed.
Regards
Dan
Red Gate Software Ltd
This is behaviour that we haven't seen before. We need to investigate it in further detail.
Could you send us some screen shots, and your database to support(at)red-gate.com .
We can then try and recreate your problem and find a solution.
Thanks
Dan
Red Gate Software Ltd