Script User Rights

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CR - 02 Sep 2005 15:57 GMT

Is there an easy way to capture existing user rights from a SQL Server
instance in a scripted format and simply run the script in a new SQL Server
instance to set all of the user privileges? Thank you.

Reply to this Message

Vishal Gandhi - 02 Sep 2005 19:27 GMT

Hi ,

You could use the Enterprise Manager to Script user Rights , Right click on
the database Click on all tasks -> Generate SQL Scripts -> goto Last Tab and
look at the security options.

Hope this helps

Cheers
Vishal Gandhi

> Is there an easy way to capture existing user rights from a SQL Server
> instance in a scripted format and simply run the script in a new SQL Server
> instance to set all of the user privileges? Thank you.

Reply to this Message

CR - 26 Sep 2005 16:05 GMT

Thanks. However, I get "[SQL-DMO]CreateFile error on
"servername.databasename.DP1' error when I try to generate script???

> Hi ,
>
[quoted text clipped - 10 lines]
> > instance in a scripted format and simply run the script in a new SQL Server
> > instance to set all of the user privileges? Thank you.

Reply to this Message