Permissions issue/question
djones
Posts: 2
In using SQL Compare version 6.1.0.53 to compare several stored procedures, I discovered the permissions on the existing sproc (Execute, in this case) were not carried over to the desination.
The Ignore permissions checkbox was not checked.
If this is by design, it would be useful to be able to selectively bring these permissions across. Does SQL Compare have this capability?
If not, please consider it for a (near) future release; this is rather important when bringing sprocs over.
Thank you.
The Ignore permissions checkbox was not checked.
If this is by design, it would be useful to be able to selectively bring these permissions across. Does SQL Compare have this capability?
If not, please consider it for a (near) future release; this is rather important when bringing sprocs over.
Thank you.
Comments
What version(s) of SQL Server are you using (and on what sides of the comparison), and could you possibly send a schema snapshot, database backup, or just the script for the stored procedures in question to michelle.taylor@red-gate.com so we can reproduce the problem and hopefully get it fixed?
Redgate Software