Report SQL SERVER 2005 Permissions

By Carley Zepeda, 2008/04/17

Total article views: 794 | Views in the last 30 days: 687

Rate this |

Join the discussion |

Briefcase

I wrote this script because I wanted to migrate permissions from one database to another and couldn't easily get ahold of the schema-level permissions I knew I had granted.

TO USE:

set the parameters for REPORT, GRID or SCRIPT (DEFAULT IS GRID).

execute

By Carley Zepeda, 2008/04/17

Total article views: 794 | Views in the last 30 days: 687

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

What does SMO mean in SQL Server 2005?

By Krishna Sonti | Category: SQL Server 2005

(not yet rated) | 1,872 reads

What is database mirroring?

By Steve Jones | Category: SQL Server 2005

(not yet rated) | 2,172 reads

If you setup database mirroring, do you need...

By Steve Jones | Category: SQL Server 2005

(not yet rated) | 1,552 reads

What is the role of a witness in...

By Steve Jones | Category: SQL Server 2005

(not yet rated) | 1,344 reads

Like this? Try these...

Testing all procs before upgrading to Compatibility Level 90

By Luiz Barros | Category: Compatibility

| 602 reads

Send query result as HTML Mail

By EYER Daniel | Category: Mail

| 832 reads

Moving Databases

By Andy Warren | Category: Administration

| 6,903 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