Public Role

In BOL (regarding the Public Role) it states, as one of its functions:
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200511/1
Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions to
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via droptable.com" wrote:

> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200511/1
>
|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200511/1