Copy User permission

From: Alex (anonymous_at_discussions.microsoft.com)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 06:33:52 -0700

Hi

We are migrating Windows user to amnother domain, but sql
server windows users have sid, and name hard coded to the
SQL Server

What we are planning is to create new set of users from
the new domain, then copy the permission from the old
domain users to the new domain users.

Is there a quick way to copy permission from an existing
login id to a new login id?

Thanks

Alex

Relevant Pages

  • RE: Authenticate via Active Directory from PC thats not joined the do
    ... I suggest that you create a SQL login for each user. ... Make sure SQL server use mixed mode Authentication. ... You can refer to the following ... Granting a Windows User or Group Access to a Database ...
    (microsoft.public.sqlserver.security)
  • AUTHENTICATION TO APPLY SP3
    ... a problem with SP3? ... > SQL Server 2000 RTM Standard Edition ... >windows user. ... >These accounts and passwords are good because I can get ...
    (microsoft.public.sqlserver.security)
  • Re: ASP.NET Forms Authentication Via A SQL Server Database With Windows User types?
    ... we have decided to go with SQL Server security vs Windows (using ... Standard SQL Users, not the Windows Users) - it just seems to be the ideal ... The Windows user type in SQL Server uses the security context of the ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Using a specific user as PublisherLogin
    ... This is based upon whether your replication SecurityType is set to ... Windows User on the machine or has DB privileges on the SQL server. ... NTAuthentication settings are the easiest to setup for users who have ...
    (microsoft.public.sqlserver.ce)
  • Re: Get Login
    ... In "Windows Authentication mode" the system_user returns the ... Sql Server can't know the Windows User name if the Authentication is "SQL ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)