• You'll need a role in each database.  You may want to create it in model so all of the new db's get it.

     

    Script out the CREATE ROLE and GRANT <PRIV> statements.  It should be fairly easy to migrate them from one database to the next.


    "Keep Your Stick On the Ice" ..Red Green