Public Role Permissions

I have a system that before I arrived, they granted all permissions to all
objects to the public role instead of creating there own. While in the
process of trying to fix this we discovered that all users through the publi
c
role have the ability to create objects.
Ultimately what I need to know is how do I revoke or remove permissions to
the public role?Hi,
You will need to create new roles and assign the required permissions the
role. After that assign the approprate roles to users.
Once you are done with that then you could use ROVOKE command remove the
permissions from Public role. The only way to rovoke
Public role rights is to Rove the permissions.
Thanks
Hari
SQL Server MVP
"Rick" <Rick@.discussions.microsoft.com> wrote in message
news:43353E72-E45B-4048-BA73-E84000DFEA4D@.microsoft.com...
>I have a system that before I arrived, they granted all permissions to all
> objects to the public role instead of creating there own. While in the
> process of trying to fix this we discovered that all users through the
> public
> role have the ability to create objects.
> Ultimately what I need to know is how do I revoke or remove permissions to
> the public role?