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,414 reads

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,660 reads

Blogs

The Data platform has evolved – so too must the DBA.

By

This blog post is around the changing landscape of both SQL Server and the...

What does the Machine Learning process look like?

By

This is the second article in the Machine Learning area. I have explained a...

Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions

By

In this article, we will focus on creating a data pipeline to ETL (Extract,...

Read the latest Blogs

Forums

Container Ports

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Container Ports

Receiving timeout errors on SQL2014

By Dhruva_51

Similar to the one mentioned in the below article. We are sql server build...

Continue SQL Server transactional replication with AWS DMS

By tttcoding

Hello, I have a task for which I wasn't able to find much information...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers