Re: Public Role in SQL Server 2000 SP3

From: Peter (anonymous_at_discussions.microsoft.com)
Date: 07/13/04 

Date: Mon, 12 Jul 2004 21:49:27 -0700

If I want him to select all tables, what is the easiest
way to achieve it ?

Thanks

>-----Original Message-----
>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: Directory Permissions - What gives?
    ... You control security at the NTFS ... As far as best practices are concerned in the "old days" as ... You use NTFS Folder and File permissions for that. ...
    (microsoft.public.windows.server.general)
  • Re: change user1 access changes user2 access
    ... Using the public role is your problem. ... All users, whether it be User1, ... permission you are granting All users the permissions. ... > name, a password, I select a database to login to, then go ...
    (microsoft.public.sqlserver.security)
  • Re: SMS View Tables access through ODBC - Help!
    ... > view tables is required for a feed to a third party asset management tool. ... Is public role necessary to access view tables? ... with a standard user account to make sure that nothing bad happened. ... enable the select permissions to the objects you want them to view. ...
    (microsoft.public.sms.admin)
  • Re: change user1 access changes user2 access
    ... > Using the public role is your problem. ... >permission you are granting All users the permissions. ... I click on New Login. ... >> name, a password, I select a database to login to, then ...
    (microsoft.public.sqlserver.security)
  • Re: Public Role in SQL Server 2000 SP3
    ... 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. ...
    (microsoft.public.sqlserver.server)