|
Home > Archive > MS SQL Server security > September 2005 > Script User Rights
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Script User Rights
|
|
|
| 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.
| |
| Vishal Gandhi 2005-09-02, 1:23 pm |
| 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
"CR" wrote:
> 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.
>
>
>
| |
|
| Thanks. However, I get "[SQL-DMO]CreateFile error on
"servername.databasename.DP1' error when I try to generate script???
"Vishal Gandhi" < VishalGandhi@discuss
ions.microsoft.com> wrote in message
news:0C04E96C-CDD9-4F54-B5CA- C213CAD97127@microso
ft.com...
> 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[color=darkred]
> look at the security options.
>
> Hope this helps
>
> Cheers
> Vishal Gandhi
>
>
> "CR" wrote:
>
Server[color=darkred
]
|
|
|
|
|