Grant Permission to one User RRS feed

  • Question

  • Hi All,

    We have set Database in Single_User mode, but we should grant permission to one user. How we can grant it?


    Monday, May 28, 2012 12:25 PM


  • I'm not sure what you are trying to accomplish but is your intention to allow only that one user access the database?  In that case, you can create the desired database user (if it doesn't already exists) and drop other users.

    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

    • Proposed as answer by Maggie Luo Tuesday, May 29, 2012 7:13 AM
    • Marked as answer by Maggie Luo Wednesday, June 6, 2012 9:33 AM
    Monday, May 28, 2012 12:30 PM