Re: Public Role in SQL Server 2000 SP3

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 09:58:39 +0530

Hi,

The public role is a special database role to which every database user
belongs. Captures all default permissions for users in a database.

The user with public role can access only the tables / objects granted
permissions exclusevely to PUBLIC role.

For eg:

Hari is a database owner and he create a table customer. After creation he
gave the below statement to give previlage to customer table.

GRANT select on customer to public

IN this case user inside public role will be able to access the table
customer. Otherwise he can not. 

--
Thanks
Hari
MCDBA
"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: 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: 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: Newbie: I dont understand user permissions for table access
    ... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
    (microsoft.public.sqlserver.server)
  • Re: PUBLIC ROLE
    ... think of the Public role as being very much ... > If I create a database called "TEST" and make a user George database ... you grant those permissions to the public role. ...
    (microsoft.public.sqlserver.security)
  • Re: new userID can do all...
    ... Being in the public role in a database shouldn't give you access to do ... >>>> No server roles have been assigned. ... >>> Does he have administrative rights to the box ...
    (microsoft.public.sqlserver.security)