Re: Change logins domain in SQL2000 with Windows 2000

From: Javier Rosas (jrosashe@accival.com.mx)
Date: 10/31/02 

From: "Javier Rosas" <jrosashe@accival.com.mx>
Date: Thu, 31 Oct 2002 13:09:40 -0800

Yes, but that sp is only to reattach logins with the users
in database, but suppose that

I have a user Domain_nt\javier with access to database Pubs
I change users domain, now my Domain_nt\javier user
doesn't exist, now I will create the user
NewDomain\javierrosas

Has my user NewDomain\javierrosas the same permissons as
Domain_nt\javier or I have to add access to Pubs database
again?

Thanks again.
Javier Rosas

>-----Original Message-----
>Javier,
>
>If you change domains you will have to resolve the
logins. You can use
>sp_change_users_login to resolve them. See BOL.
>
>Ron
>--
>Ron Talmage
>SQL Server MVP
>
>"Javier Rosas" <jrosashe@accival.com.mx> wrote in message
>news:7ac701c2808b$fa37de10$3bef2ecf@TKMSFTNGXA10...
>> Hi all,
>>
>> I will upgrade WinNT to Windows 2K and I will upgrade
SQL7
>> to SQL2K, too.
>>
>> I have a dude, I need to change my users to another
>> domain, with a procedure and a tool, they mantain the
same
>> policy permissions in OS, my question is: what's up with
>> my users in SQL? Do I need to add each login again and
>> asign permissions again or exist any procedure to change
>> all SQL logins with the same permissons when they change
>> of domain?
>>
>> I think, it's like renaming the login in syslogins or
>> sysxlogins.
>>
>> Anybody help me?
>>
>> Thanks in advance.
>> Javier Rosas
>
>
>.
>

Relevant Pages

  • Re: Logging in irrespective of database access
    ... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Changing security authentication type.
    ... i'm thinking that yes in time the sa account ... A new DBA Admin User login would only be useful for SQL Login purposes. ... if appropriate you can add users to the db_owner role in a database. ... Create one or more logins for the applications. ...
    (microsoft.public.sqlserver.security)
  • Re: Help Ive been an idiot
    ... You need to make sure that you readd any logins that were mapped to database ... Jasper Smith (SQL Server MVP) ... > connectionString, CommandType commandType, String commandText, ...
    (microsoft.public.sqlserver.setup)
  • RE: Creating a DB User *not* on current Machine
    ... detach/attach the database to a new server. ... Server.When you move a database from one server that is running SQL Server ... the security identification numbers of the logins in the master ...
    (microsoft.public.sqlserver.security)