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: Getting Logged in Windows user name
    ... I need to know the login the user used on the machine which is hosting the ... the myappfolder is protected by windows security in IIS and therefore ... Once the user has logged in the app is deployed to ... >> The user is not a domain user and has to log onto the machine when they ...
    (microsoft.public.dotnet.security)