Post reply

grant access to see and able to read, write to the databases created by one user to other

  • January 20, 2016 at 11:46 am

    #310970

    Hi,

    I have a user called USER 1 with dbcreator and securityadmin roles. He created a database DB1 and this database should be accessed by another USER 2. But he is not able to. Please advise.

    USER 2 also have dbcreator and securityadmin roles

    Thanks.

  • January 20, 2016 at 12:15 pm

    #1853259

    User2 has to be created with the correct roles and permissions in the new database.; permissions in the old db would not make any difference;

    sounds like he has rights in DB1, but not the new one.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 21, 2016 at 8:59 pm

    #1853691

    gary1 (1/20/2016)

    Hi,

    I have a user called USER 1 with dbcreator and securityadmin roles. He created a database DB1 and this database should be accessed by another USER 2. But he is not able to. Please advise.

    USER 2 also have dbcreator and securityadmin roles

    Thanks.

    As user 1 has dbcreator server role, when they create a database they are automatically added as the owner of the database. Authentication for this user maps through the fixed account dbo, this user has full access.

    User2 would need to be explicitly granted permission to access this database and its objects, the server roles held do not grant permission to existing databases or ones they haven't created.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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