Re: Public Role in SQL Server 2000 SP3

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/13/04 

Date: Mon, 12 Jul 2004 23:37:18 -0500

The default permissions of the public role allow SELECT from sysobjects and
other meta-data objects.

A security best practice is to create your own roles and grant object
permissions to those roles as needed. You can then control security by user
role membership. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter" <anonymous@discussions.microsoft.com> wrote in message
news:2b73701c46890$d144c1a0$a501280a@phx.gbl...
> If I add a user to a database with Public Database Role, I
> would like to know what privilege has been granted to him.
>
> This is because we find that he is not able to SELECT any
> table.

Relevant Pages

  • Re: System Tables and Public Role
    ... type of security in mind, I guess we need to "trial and error" the security ... Take permissions away and test to see if something ... >> public role for any database objects. ... Am I to assume that the public role requires these ...
    (microsoft.public.sqlserver.security)
  • RE: What server hardening are you doing these days?
    ... permissions on their data, and Microsoft encourages ISVs to minimize ... I've been able to discuss ACLs and other security issues in Windows with ... Control or DAC (which is what you're referring to by the "stupid ...
    (Focus-Microsoft)
  • Re: get rid of security center?
    ... I have come up with a solution that does not disable Security Center, ... By changing the Permissions of that key, ... settings from being changed again. ... the firewall alert settings in Security Center get ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Password Protect IExplore
    ... You can protect the files and folders you store on your computer to make ... To set, view, change, or remove special permissions for files and folders ... clear the Inherit from parent the permission entries that apply ... To configure security so that the subfolders and files will not ...
    (microsoft.public.internet.explorer.ieak)
  • Re: Removing the Internet Security in SP2
    ... I have come up with a solution that does not disable Security Center, ... By changing the Permissions of that key, ... settings from being changed again. ... the firewall alert settings in Security Center get ...
    (microsoft.public.windowsxp.security_admin)