SQL Delta Logo
SQL Delta Banner

Schema compare, permission order

Support and information about SQL Delta for SQL Server Version 5

Schema compare, permission order

Postby rmjcsltd » Mon Apr 29, 2013 10:46 am

Hi,

First off, love SQL Delta - great piece of work!

Secondly, this has been niggling me for a while so I thought I'd log the issue. I'm comparing 2 dev versions of the same database on the same SQL 2008 R2 server. I have a schema defined for which a number of database roles have been granted execute permission. For some reason SQL Delta sees the GRANTs in a different order on the 2 databases and treats them as different. For example, the GRANTs in bold below (SQL Delta structure comparison output) are treated as differences, but as can be seen, the only difference is their position in the list.

Regards,
Rhys

-- -----------------------------------------------
-- Database 1
-- -----------------------------------------------
-- Schema
CREATE SCHEMA [mpas] AUTHORIZATION [dbo]

-- Permissions

GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_Test]
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_BancWare]
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_PMR]
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_BSSDAT]
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_TDR]
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_Garnet]

-- -----------------------------------------------
-- Database 2
-- -----------------------------------------------
-- Schema
CREATE SCHEMA [mpas] AUTHORIZATION [dbo]

-- Permissions
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_BancWare]
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_Test]
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_BSSDAT]
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_PMR]

GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_TDR]
GRANT EXECUTE ON SCHEMA::[mpas] TO [mpas_Garnet]
rmjcsltd
 
Posts: 1
Joined: Mon Apr 29, 2013 10:35 am

Re: Schema compare, permission order

Postby david » Tue Jun 25, 2013 2:10 am

The is an update available that fixes this issue.
david
Site Admin
 
Posts: 423
Joined: Mon Nov 10, 2003 11:22 pm


Return to Support Version 5