SQLPermissionsScriptor

Rating: No reviews yet
Downloads: 79
Released: Mar 8, 2016
Updated: Mar 8, 2016 by yportes
Dev status: Stable Help Icon

Recommended Download

Application SQLPermissionsStractor
application, 12961K, uploaded Mar 8, 2016 - 79 downloads

Release Notes

Generates All SQL Users and Logins and their permissions, including original password, database, object and column level permissions.

Tested on: SQL 2005, 2008, 2008 R2, 2012, 2014, 2016 CTP3

REQUIRES:
  • sysadmin SQL Server role
  • .NET framework 4.6

FEATURES:
*IncludeLogin: Scripts out the CREATE script for the SQL Login associated with each Database user.
*RetainSID: Scripts Login with SID= keyword, so the user does not become an orphan if transferred to another SQL Server.
*IncludeIfNotExists: Will add code to CREATE when user, role or schema does not exists on the server/database where code will be executed.
*CreateRoles: Creates all user-created database roles.
*CreateSchema: Creates all user-created Schemas.
*IncludeSystemObjects: Will script out all system users/logins/roles/schemas along with user-created ones.

IT DOES NOT GENERATE SERVER LEVEL PERMISSIONS OR ROLES.
For help with SQL Server yportes@fusionlane.com

Reviews for this release

No reviews yet for this release.