Public role exists for any new login in sql server 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeetu - 13 Nov 2008 12:13 GMT

Hi All,

I have a query regarding the Default Public role to any New SQL Server Logins.

Its exists by default
can it be removed ??
Has Microsoft given any recommendations about this behaviour??

Please let me know.

Regards,
Jeetu

Reply to this Message

Uri Dimant - 13 Nov 2008 13:02 GMT

>can it be removed ??

>Has Microsoft given any recommendations about this >behaviour??

Deny any permissions to public role

> Hi All,
>
[quoted text clipped - 9 lines]
> Regards,
> Jeetu

Reply to this Message

Rick Byham, (MSFT) - 17 Nov 2008 18:25 GMT

Slight correction. Don't "deny" permissions. Everyone is a member of public
and deny's override grants, so no one would have access. Just don't grant
any permissions to Public.

Signature

Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

> >can it be removed ??
> No
[quoted text clipped - 14 lines]
>> Regards,
>> Jeetu

Reply to this Message

Uri Dimant - 18 Nov 2008 06:54 GMT

Thanks Rick , that is what I had in my mind.

> Slight correction. Don't "deny" permissions. Everyone is a member of
> public and deny's override grants, so no one would have access. Just don't
[quoted text clipped - 17 lines]
>>> Regards,
>>> Jeetu

Reply to this Message

Tom Moreau - 13 Nov 2008 13:04 GMT

Users - not logins - belong to database roles. Everyone belongs to the
public role and this cannot be changed. By default, the public role has no
permissions granted to it. This should not cause a problem.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

Hi All,

I have a query regarding the Default Public role to any New SQL Server
Logins.

Its exists by default
can it be removed ??
Has Microsoft given any recommendations about this behaviour??

Please let me know.

Regards,
Jeetu

Reply to this Message