Public Role Permissions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick - 21 Sep 2006 17:15 GMT

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?

Reply to this Message

Hari Prasad - 22 Sep 2006 04:08 GMT

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

>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
[quoted text clipped - 4 lines]
> Ultimately what I need to know is how do I revoke or remove permissions to
> the public role?

Reply to this Message