Security Access ADP and Sql Server

From: applenot (andrewsv_at_homemail.com)
Date: 08/25/05 

Date: 25 Aug 2005 13:21:52 -0700

I am attempting to add security other than windows security to my
Access ADP conversion and SQL Server 2000. All work is done from VBA.
I can add a new login with sp_addLogin. I can add to the role with
sp_addRoleMember but I can't find the Store proc for attaching the
databases to the logins. Any help?

Relevant Pages

  • Re: Security Access ADP and Sql Server
    ... SQL Books Online is where to go to look up syntax. ... >Access ADP conversion and SQL Server 2000. ... All work is done from VBA. ... >I can add a new login with sp_addLogin. ...
    (microsoft.public.sqlserver.security)
  • Re: Utter madness!
    ... It is just Windows security stuff. ... You can get a trusted connection back to SQL server. ... ASP.NET account (either processModel or app pool identity depending on ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Login Interactively
    ... much indicate some systemic failure of domain infrastructure. ... Microsoft MVP (Windows Security) ... >> I just enabled group policy so that all of the machines would get ... >> If I reboot sometimes it will let them login. ...
    (microsoft.public.windows.server.security)
  • Re: How to move current SQL server from Domain A to Domain B?
    ... SQL Server security? ... If you are using Windows security and are ... removing the domain you will have to recreate your security setup. ... > "Keith Kratochvil" wrote in message ...
    (microsoft.public.sqlserver.setup)
  • Re: No Application Logins Allowed - SOX
    ... Individual users don't have to be added to databases; Windows security ... This may also hit performance. ... windows users make use of the login. ...
    (microsoft.public.sqlserver.security)