Posted by Simon Hayes on 08/11/05 02:45

"LM" <nospam@nospam.no> wrote in message
news:42fa5268$0$18640$14726298@news.sunsite.dk...
> 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
>
>

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

[Back to original message]