george sibbald

Reverse-Engineer Database Permissions (2005 up)

This script reverse engineers SQL statements to recreate database permissions.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.33 (6)

2011-10-24 (first published: 2011-10-07)

9,528 reads

For anyone who read the title of this and immediately thought, “Oh no, I...

TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Hello all, I've been tasked (rather randomly) with finding out if there is somewhere...

We get a sql connection from host informatica server and the query runs in...

I am trying to write a query to get a list of all SQL...