Re: Copy User permission

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

  • Next message: SA Dev: "I can only connect via Windows Auth - WHY?" 
    Date: Tue, 21 Sep 2004 08:32:59 -0700

    Gregory

    Thank you very much. It is exactly what I have been
    looking for. Thanks a million!

    Alex

    >-----Original Message-----
    >I wrote an article for SQL Server Magazine that has a SP
    to accomplish what
    >you are asking. Here is where the article is, hopefully
    you are a
    >subscriber so you can read this:
    >
    >http://www.windowsitpro.com/Article/ArticleID/41181/41181.
    html
    >
    >--
    >
    >----------------------------------------------------------
    ------------------
    >----------------------------------------------------------
    ------------------
    >-
    >
    >Need SQL Server Examples check out my website
    >http://www.geocities.com/sqlserverexamples
    >
    >
    >"Alex" <anonymous@discussions.microsoft.com> wrote in
    message
    >news:0a1301c49fdf$a2245530$a601280a@phx.gbl...
    >> 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
    >
    >
    >.
    >

  • Next message: SA Dev: "I can only connect via Windows Auth - WHY?"

    Relevant Pages

    • RE: OpenDataSource "Unspecified Error" when connecting to local Excel
      ... Are there any another hidden permissions required for the OpenDataSource ... the file is on the local Sql Server. ... > Even if I add domain users to the server administrator role, ... > local administrators group on the Sql Server? ...
      (microsoft.public.sqlserver.connect)
    • Re: {permissions} How should I do this?
      ... We are using Sql Server 2005. ... Our database server is a win2k3 machine. ... that he has access to everything Domain Users has access to. ... If that account is suppose to be of use on a machine it will need to be ...
      (microsoft.public.windows.server.security)
    • Re: Basic Windows Authentication Question
      ... Create OS Group and all the domain users to that group. ... that domain group to SQL Server. ... "Gorge Bush" wrote in message ... > as a login in SQL Server. ...
      (microsoft.public.sqlserver.security)
    • Re: What type of Server Roles to assign for Backup and Recovery
      ... Have figure out assigning a limited Windows Domain acc but when login ... group of user other then Domain Users and Domain Admins to access the disk ... Using the db_backupoperator and the db_creator roles for a sql server ...
      (microsoft.public.sqlserver.security)
    • Re: Using Sql Server 2000 Username/Password/Roles with ASP.Net 2.0 ?
      ... You can use full SQL Server security, but realistically, you have to have domain users to do it. ... I don't want to save the Username/Password in Connectionstring of Web.config. ... I need forms Authentication as my users are on Internet and not on my Local Windows Domain. ...
      (microsoft.public.dotnet.framework.aspnet)