Script Login Roles Permissions in all DBs _SQL2005

By TDuffy, 2006/08/16

Total article views: 1107 | Views in the last 30 days: 154

Rate this |

Join the discussion |

Briefcase

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 logins, see section /*To Script all sql and windows logins...

By TDuffy, 2006/08/16

Total article views: 1107 | Views in the last 30 days: 154

Your response

Rate this |

Join the discussion |

Briefcase

Like this? Try these...

Alphanumeric and Special Character Validation- New

By ramesh_kondaparthy | Category: T-SQL Aids

| 134 reads

Get DBObjects with Specified Owner

By Bhavesh | Category: Maintenance and Management

| 165 reads

Grant Object Permissions to Role/User in mult DBs

By alext | Category: Miscellaneous

| 601 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com