Home Forums SQL Server 2008 SQL Server 2008 Administration user permission RE: user permission

  • November 27, 2012 at 5:58 am

    #1562628

    i believe if a login belongs to the sysadmin group, and you create a user for the login in any database, the db)owner checkbox gets inherited as readonly ; that's what you are seeing, i think.

    can you check the login and see if it is a sysadmin?

    also check to see if the windows group is sysadmin, and since the user belongs to that group, it's the same effective permissions.

    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!