Wednesday, March 7, 2012

Only Public is selected but users can still create tables?

Hi all,
I've come into a situation where there is a Windows domain users group that
has access to a database and can create tables but only has the public
role(?). Is there somewhere else this role is set to allow this? It's for a
third party application. -Thanks, DaveHave you checked the detailed permissions applied to 'public' on that db?
Chris
"dfate" <dfate2001-rock@.yahoo.com> wrote in message
news:uaWHi5pHFHA.3072@.tk2msftngp13.phx.gbl...
> Hi all,
> I've come into a situation where there is a Windows domain users group
> that has access to a database and can create tables but only has the
> public role(?). Is there somewhere else this role is set to allow this?
> It's for a third party application. -Thanks, Dave
>|||"dfate" <dfate2001-rock@.yahoo.com> wrote in message
news:uaWHi5pHFHA.3072@.tk2msftngp13.phx.gbl...

> I've come into a situation where there is a Windows domain users group
that
> has access to a database and can create tables but only has the public
> role(?). Is there somewhere else this role is set to allow this? It's for
a
> third party application. -Thanks, Dave
>
If you've taken the default SQL Server installation for security, there is a
BUILTIN\Administrators group that gives anyone with administrative rights on
the server sysadmin equivalence on SQL Server. Check that those users are
not administrators on the server itself, or are domain admins.
Steve

No comments:

Post a Comment