Post reply

Domain Windows group access on SQL server

  • January 21, 2010 at 8:29 am

    #138428

    I am having a server in domain, in which i have one domain group with admin rights.

    Now i gave this domain group windows authenticated access to SQL server only with public rights. But the problem is that, the user in this group is still able to update records in respective database. Though i have not given sysadmin rights on SQL server level to this group, but he can update records

    Note: I have removed sysadmin rights for BUILTadministrator.

    So what can be the issue? Can any one help me out in this.

    Thank you.

  • January 21, 2010 at 8:35 am

    #1106739

    Hello Arpan,

    Did you check the permissions for Public role? If the public role has the ability to update records, then that would explain why the specific user is able to update record.

  • January 21, 2010 at 9:00 am

    #1106770

    try this

    sp_helprotect NULL, 'public'

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

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