Technical Article

Script Login Roles Permissions in all DBs _SQL2005

Usage -Populate @list variable below with account(s),comma delimited list to script. -Save output to recreate:Login,Default DB,Server Roles,DB Access,DB Roles,DB Object Permissions. -- NOTE: -Stored procedures are created in Master, but are deleted -to limit by database see section /*Get a table with dbs where login has access*/ and change the where clause -to script all […]

4.75 (8)

2007-02-01 (first published: )

4,425 reads

Technical Article

Script Login Roles Permissions in all DBSs

Populate @list variable with account(s) to script. Save output to recreate:Login, Password,Default DB,Server Roles,DB Access,DB Roles,DB Object PermissionsDB level permissions are scripted in all databases. Can recreate a single login, or accepts comma delimted list of logins.NOTE:Stored procedures are created in Master, but are deleted

2006-01-19 (first published: )

1,699 reads

Blogs

STRING_SPLIT Basics–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

Read the latest Blogs

Forums

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

SET STATISTICS equivalent

By DamianC

Hello Is there an equivalent for monitoring things like IO, reads, writes, ... produced...

Using HttpClient in SSIS Script Component with visual studio 2015 framework4.8

By wiam.elab

Hi, I'm using HttpClient in an SSIS script component to retrieve data from a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers