transfering users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

natasa - 25 Jul 2006 15:37 GMT

Hi ,

I need to replace the existing database with the new database but keep all
users.
How can I transfer the users to the new database ?
Since the new database name has to be the same as the old, I just planned to
restore the new db over the existing one but how would I go around the
problem with the users. Is there a script that can be used to script existing
permissions and then set them back in the new database ?

Thanks very much,
natasa

Reply to this Message

Brett I. Holcomb - 25 Jul 2006 15:53 GMT

I just went through this. There is a Knowledge base article on
sp_help_revlogin procedures that move from the old to the new and bring
over the IDs and passwords. I tried various techniques including the DTS
wizards but this KB article was the best way I found to do it.

> Hi ,
>
[quoted text clipped - 8 lines]
> Thanks very much,
> natasa

Reply to this Message

natasa - 25 Jul 2006 16:17 GMT

Hi,

I found the same article but this won't help since I am not transfering the
logins between two instances of SQL server. I just want to transfer the users
to the new database that will reside on the same server. Basically all logins
will still exist once I delete the old database but the users will be
orphaned and default db will be master without any permission in any database.

Thanks again,
natasa

> I just went through this. There is a Knowledge base article on
> sp_help_revlogin procedures that move from the old to the new and bring
[quoted text clipped - 13 lines]
> > Thanks very much,
> > natasa

Reply to this Message

Arnie Rowland - 25 Jul 2006 16:10 GMT

This kb article may help:

http://support.microsoft.com/kb/246133/

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

> Hi ,
>
[quoted text clipped - 10 lines]
> Thanks very much,
> natasa

Reply to this Message

natasa - 25 Jul 2006 18:55 GMT

Thanks Arnie...however the article you are talking about is the same as the
one mentioned by Brett . I am not talking about moving the logins between
the instances...my old db will be gone and the new db on the same instance
will have to have same users as the old one.How to accomplish this?Any other
suggestion?

Thanks anyway,
natasa

> This kb article may help:
>
[quoted text clipped - 14 lines]
> > Thanks very much,
> > natasa

Reply to this Message

Sue Hoegemeier - 28 Jul 2006 18:10 GMT

Database users are stored in a system table in the database
so the users will be in the database and will be present
when you restore the database. If the logins and same sids
already exist on the server, the users should not be
orphaned.

-Sue

>Thanks Arnie...however the article you are talking about is the same as the
>one mentioned by Brett . I am not talking about moving the logins between
[quoted text clipped - 23 lines]
>> > Thanks very much,
>> > natasa

Reply to this Message