What is the proper way to set permissions in sqlserver 2008 (express)? RRS feed

  • Question

  • I have a database that is accessed by an application for data updates.

    I want to use windows authentication with a domain group

    I have created a login with the domain group then created a user in the appropriate database with that login

    I have created a database role with select,update,delete,insert rights on the appropriate tables.

    The application works fine with a separate user that has a login and user with the required permissions but when a member of the domain group runs the app they can connect to sqlserver but do not have access to the tables.

    In Oracle I would create the role, add table permissions to the role and assign the role to the user,

    I can't figure out how to accomplish the same thing in sqlserver 2008



    Friday, October 15, 2010 3:25 PM


  • As so often happens I found the answer after asking the question.

    In my tests I had a default schema set for the developer and test user.

    I cannot set a default schema on a windows group login so the connection string needed to include the database.


    • Marked as answer by Tom Li - MSFT Monday, November 1, 2010 8:36 AM
    Friday, October 15, 2010 4:02 PM