Copy permissions

[LM]

Hi,

I have 1 developement Database and 3 databases for 3 different countries.
They are all located at the same server.

I have the same tables and the same roles in each database. I want to make a
script, which can copy role permissions from the development db to all the
country databases. Is it possible?

LM

[Simon Hayes]

Re: Copy permissions


"LM" <nospam@nospam. no> wrote in message
news:42fa5268$0 $18640$14726298 @news.sunsite.d k...[color=blue]
> Hi,
>
> I have 1 developement Database and 3 databases for 3 different countries.
> They are all located at the same server.
>
> I have the same tables and the same roles in each database. I want to make
> a
> script, which can copy role permissions from the development db to all the
> country databases. Is it possible?
>
> LM
>
>[/color]

Yes - roles are defined in each database, so you should be able to run a
script in multiple databases without problems, provided that the necessary
logins exist. In Enterprise Manager, you can script objects with the
"database users and database roles" option.

Simon