Re: how to specify domain SLASH user in Query Analyzer when creating users and granting permissions

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 01/30/04 

Date: Fri, 30 Jan 2004 11:54:46 -0500

Timo,

Logins can have the slash, but users cannot. Once you have added the login,
just:

sp_grantdbaccess 'DOMAIN\USER' -- let the username default

Russell Fields

"Timo" <timo@nowhere.org> wrote in message
news:MPG.1a8429d271681a829896e0@msnews.microsoft.com...
> In Query Analyzer I am trying to execute SPs creating logons and
> granting permissions but the DOMAIN\USER format is illegal because
> of the SLASH character. How do youreference a specific
> domain\user in QA?
>
> I'm trying to set up logons and object permissions for SQLServer
> 2000 in a mixed Windows Authentication / SQL Server Authentication
> environment, using Windows Authentication. Specifically, I'm
> trying to grant the built-in SERVERNAME\ASPNET user access to
> certain databases and then grant it some object permissions. IIS
> and SQL2000 are running on the same machine.
>
> I'm working in Query Analyzer because the Enterprise Manager
> dialogs seem to get confused when we pick users from the list
> after having specified the domain: EM keeps displaying an error
> like "{myusername} already exists", but the error message does not
> give the domain\ chunk of the username. Is EM ignoring the domain
> prefix? Is this a known bug?
>
> Thanks for the help.
> Timo
>

Relevant Pages

  • Re: Scheduled tasks "Could not start"
    ... login in with the Administrator username and pw from terminal services). ... the other scheduled tasks under other logins continued to run without ...
    (microsoft.public.windows.server.security)
  • Re: Scheduled tasks "Could not start"
    ... protected storage and that changing it fixed the problem. ... that account obviously was not changed in the local sam since you could ... login in with the Administrator username and pw from terminal services). ... the other scheduled tasks under other logins continued to run without ...
    (microsoft.public.windows.server.security)
  • Re: Sample C# code with user logins/passwords?
    ... logins into the website: this will vary widely depending on what you want to ... database to store username and password information or are you going to use ... xml files....You get the idea. ...
    (microsoft.public.dotnet.languages.csharp)
  • MS Access LDB file (lock) and INSERT Failure
    ... I first check if username is unique by ... "INSERT INTO Logins ... "Syntax error in INSERT INTO statement." ... I suspect my first reading to Logins table caused ldb ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: cant access the portal from my box
    ... Are you submitting domain name + back slash + username? ... If not it assumes server name + back slash + username ...
    (microsoft.public.sharepoint.portalserver)