Public permissions

Why is the Public group granted permission to the systables in my database?
Is it safe to remove the select permission from all the sys tables?"Mike" <annon@.hotmail.com> wrote in message
news:OzWZVzbGFHA.2412@.TK2MSFTNGP14.phx.gbl...
> Why is the Public group granted permission to the systables in my
database?
> Is it safe to remove the select permission from all the sys tables?
>
Think of "public" as the "everyone" group in NT. It allows the basic,
minimum permissions to the database. Read the following for a better
understanding:
http://www.microsoft.com/technet/pr...s/c05ppcsq.mspx
You can remove the select permission from public, be aware that this may
cause other issues with stored procedures, etc.
Steve|||SQL Server uses the system tables internally for some
functions and that's why public has permissions on these
tables. There are functions such as resolving names using
internal ids stored in the system tables. And what
permissions are needed on which tables gets further
complicated by what data access mechanisms are used by what
drivers or providers using what applications or tools. Can
you remove them across the board and not have any problems?
Across the board...no. And it's no simple task to go through
and figure or what can and can't be changed.
-Sue
On Wed, 23 Feb 2005 10:30:33 -0500, "Mike"
<annon@.hotmail.com> wrote:

>Why is the Public group granted permission to the systables in my database?
>Is it safe to remove the select permission from all the sys tables?
>