What are the challenges you face when working across database platforms? Take the survey
Options

Stored procedure and GRANT EXECUTE permissions

jdnepjdnep Posts: 5
edited March 9, 2005 12:21PM in SQL Compare Previous Versions
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? :?

Comments

  • Options
    Hi

    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
    Daniel Handley
    Red Gate Software Ltd
  • Options
    That is correct. I am running version 3.1.8.276
  • Options
    Hi
    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
    Daniel Handley
    Red Gate Software Ltd
This discussion has been closed.