Copy DB user security accounts to another DB

By sam_indra1 ·
please copy the security accounts and their rights from the old db?s to the new ones (on MS SQL environment).

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Which versions and which security mode(s) ?

by Tony Hopkinson In reply to Copy DB user security acc ...

Gnerally you'd be off using the enterprise / sql desktop to script these out and then running the script against the new data base.

Careful though User Fred is just a human readable name for a db object of type user. Drop him and create a new Fred give you a new thing, it ain't putting back the old one.

Just like windows users.

Related Discussions

Related Forums