Permissions on objetcs when using command line utility

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong, JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Permissions on objetcs when using command line utility

Postby cebnet » Thu Nov 08, 2012 7:34 pm

Is it possible to extract permissions on objects in a database when creating a snapshot using the command line utility
cebnet
 
Posts: 1
Joined: Thu Nov 08, 2012 5:35 pm

Postby eddie davis » Mon Nov 12, 2012 12:47 pm

Hi Cebnet,
Thank you for your post into the forum.

A SQL Compare snapshot file is a binary file containing information regarding the structure of a database. So if the database has permissions set on individual objects, the snapshot file will contain this information.

When you compare the snapshot file with another data source, you will be able to see the differences in permissions and create a deployment script.

This SQL Compare help ARTICLE contains further advice.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests