Hi,
Is there a way to export a database role.
I would like to generate a script that I can apply to
another server.. This script would essentially create this
role for me without me having to manually create it, with
all its permissions.
Thanks.
Yes. Create a DTS Package Using Copy SQL Sever Objects Task. Go to the
Options button on the Copy tab and you'll see it. I've never used it, but
would assume it would copy permissions or else it would be no good IMO.
"niv" wrote:
> Hi,
> Is there a way to export a database role.
> I would like to generate a script that I can apply to
> another server.. This script would essentially create this
> role for me without me having to manually create it, with
> all its permissions.
> Thanks.
>
Showing posts with label apply. Show all posts
Showing posts with label apply. Show all posts
Friday, February 17, 2012
Export SQL Role
Hi,
Is there a way to export a database role.
I would like to generate a script that I can apply to
another server.. This script would essentially create this
role for me without me having to manually create it, with
all its permissions.
Thanks.Yes. Create a DTS Package Using Copy SQL Sever Objects Task. Go to the
Options button on the Copy tab and you'll see it. I've never used it, but
would assume it would copy permissions or else it would be no good IMO.
"niv" wrote:
> Hi,
> Is there a way to export a database role.
> I would like to generate a script that I can apply to
> another server.. This script would essentially create this
> role for me without me having to manually create it, with
> all its permissions.
> Thanks.
>
Is there a way to export a database role.
I would like to generate a script that I can apply to
another server.. This script would essentially create this
role for me without me having to manually create it, with
all its permissions.
Thanks.Yes. Create a DTS Package Using Copy SQL Sever Objects Task. Go to the
Options button on the Copy tab and you'll see it. I've never used it, but
would assume it would copy permissions or else it would be no good IMO.
"niv" wrote:
> Hi,
> Is there a way to export a database role.
> I would like to generate a script that I can apply to
> another server.. This script would essentially create this
> role for me without me having to manually create it, with
> all its permissions.
> Thanks.
>
Export SQL Role
Hi,
Is there a way to export a database role.
I would like to generate a script that I can apply to
another server.. This script would essentially create this
role for me without me having to manually create it, with
all its permissions.
Thanks.Yes. Create a DTS Package Using Copy SQL Sever Objects Task. Go to the
Options button on the Copy tab and you'll see it. I've never used it, but
would assume it would copy permissions or else it would be no good IMO.
"niv" wrote:
> Hi,
> Is there a way to export a database role.
> I would like to generate a script that I can apply to
> another server.. This script would essentially create this
> role for me without me having to manually create it, with
> all its permissions.
> Thanks.
>
Is there a way to export a database role.
I would like to generate a script that I can apply to
another server.. This script would essentially create this
role for me without me having to manually create it, with
all its permissions.
Thanks.Yes. Create a DTS Package Using Copy SQL Sever Objects Task. Go to the
Options button on the Copy tab and you'll see it. I've never used it, but
would assume it would copy permissions or else it would be no good IMO.
"niv" wrote:
> Hi,
> Is there a way to export a database role.
> I would like to generate a script that I can apply to
> another server.. This script would essentially create this
> role for me without me having to manually create it, with
> all its permissions.
> Thanks.
>
Subscribe to:
Posts (Atom)