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,418 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,671 reads

Blogs

Deployment of Microsoft SQL database with Azure DevOps

By

Hello, data folks! I have published several articles about databases and their maintenance in...

Reflection on Talking at SQLSaturday Charlotte About Mental Health

By

On December 7, I did a session on mental illness and mental health problems...

A guide to acronyms, abbreviations, and other technical terms

By

Here’s a list of some technical terms, acronyms, and abbreviations you may have heard,...

Read the latest Blogs

Forums

reference table for errors

By samirca007

Hello everyone I have on each table of my base two columns used to...

Can we send temp table as parameter from one store procedure to store procedure

By Rock

I need to send a temp table as parameter from one store procedure to...

Backup rows tables of SQL Server database by SMO base on colums's value

By test0101

I am following this article to backup database, but in that, will be backup...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers