Public Role

Hi:
I want to remove permissions from the public role but it is not working. I
used "revoke all from public". It had worked for me before. Some of the us
ers I created are inheriting permissions from the public role. I want to r
emove those permissions fro
m the public role but the above command is not working. Any help will be gr
eatly appreciated.
ThanksSohail,
What rights are you running with? The BOL says:
Revokes all applicable permissions. For statement permissions, ALL can be
used only by members of the sysadmin and db_securityadmin roles. For object
permissions, ALL can be used by members of the sysadmin, db_securityadmin,
and db_owner roles, and by database object owners.
Russell Fields
"Sohail" <anonymous@.discussions.microsoft.com> wrote in message
news:B1540684-F053-49A0-97AA-CA4BAA02AF86@.microsoft.com...

quote:

---

> Hi:
> I want to remove permissions from the public role but it is not working.

---

I used "revoke all from public". It had worked for me before. Some of the
users I created are inheriting permissions from the public role. I want to
remove those permissions from the public role but the above command is not
working. Any help will be greatly appreciated.

quote:

---

> Thanks

---

|||Hi Russell:
Thanks for replying. I am using sa but still not working. Very confusing.
Any other thought.
Thanks|||What is the error you receive?
Adam
"Sohail" <anonymous@.discussions.microsoft.com> wrote in message
news:117BF945-B35E-445E-93CF-7AFA0EB8F968@.microsoft.com...
> Hi Russell:
> Thanks for replying. I am using sa but still not working. Very
confusing. Any other thought.
> Thanks