Post reply

Creating new user on local machine

  • May 17, 2012 at 4:34 am

    #255996

    I created a local User Test1 on my local machine just to test some schema settings. Then I added the user in Logins at the Sql server instance level. Then I added the same user in Northwind DB User's list where I gave db_read and db_write rols and restricted to a schema.

    But when I log in as this new user I cant see Northwind database at all. I did restart my machine.

    I wonder what am doing wrong..

  • May 17, 2012 at 5:27 am

    #1488915

    Did you map the database user to the SQL Login for Test1?

    e.g.

    CREATE USER Test1 FOR LOGIN Test1

    WITH DEFAULT_SCHEMA = Marketing;

    GO

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply