revoke create table from a user

[b***@traderonline.com]

I am trying to revoke the create table privilege from a user in a
database.

I have revoked create on database and on the public schema, yet I can
still create table as that user. what else do I need to do?

thanks,

Jim Bagley
Database Manager
Trader Electronic Media
[phone] (work)
[phone] (cell)

www.Employmentguide.com <http://www.employmentguide.com> - Bringing
Employers and Jobseekers Together.
www.ForRent.com <http://www.forrent.com> - Nation's Leading Apartment
Rental Source.
www.HarmonHomes.com <http://www.harmonhomes.com> - Your Home Site on the
Web.
www.ParenthoodWeb.com <http://www.parenthoodweb.com> - Pregnancy and
Parenting Advice, Baby Names and More.
www.Roomsaver.com <http://www.roomsaver.com> - 6000+ Lodging Coupons.
www.TraderOnline.com <http://www.traderonline.com> - Boats, RVs,
Collector Cars, Motorcycles and More.

[Bruno Wolff III]

On Fri, Nov 07, 2003 at 15:47:50 -0500,

Post by b***@traderonline.com
I am trying to revoke the create table privilege from a user in a
database.
I have revoked create on database and on the public schema, yet I can
still create table as that user. what else do I need to do?

Is that user a superuser? If you gave that user the ability to create
new users then they are a superuser and access controls don't apply
to them.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[b***@traderonline.com]

no, not on the database. I specified NOCREATEDATABASE and NOCREATEUSER
when creating the user. and...the user does not belong to any groups.
the user in question is bolded.


usename | usesysid | usecreatedb | usesuper | usecatupd
| passwd | valuntil | useconfig
----------+----------+-------------+----------+-----------+-------------------------------------+----------+-----------
db | 102 | f | f | f |
md589a7f6028a19c3dc081cc5f16eb53891 | |
postgres | 1 | t | t | t |
md53175bce1d3201d16594cebf9d7eb3f9d | |
webdev | 103 | f | f | f |
md5980e74dba6ed3e28daccbc8d2150c9fb | |



thanks,


Jim

Post by Bruno Wolff III
On Fri, Nov 07, 2003 at 15:47:50 -0500,

Post by b***@traderonline.com
I am trying to revoke the create table privilege from a user in a
database.
I have revoked create on database and on the public schema, yet I can
still create table as that user. what else do I need to do?

Is that user a superuser? If you gave that user the ability to create
new users then they are a superuser and access controls don't apply
to them.

--
Jim Bagley
Database Manager
Trader Electronic Media
[phone] (work)
[phone] (cell)

www.Employmentguide.com <http://www.employmentguide.com> - Bringing
Employers and Jobseekers Together.
www.ForRent.com <http://www.forrent.com> - Nation's Leading Apartment
Rental Source.
www.HarmonHomes.com <http://www.harmonhomes.com> - Your Home Site on the
Web.
www.ParenthoodWeb.com <http://www.parenthoodweb.com> - Pregnancy and
Parenting Advice, Baby Names and More.
www.Roomsaver.com <http://www.roomsaver.com> - 6000+ Lodging Coupons.
www.TraderOnline.com <http://www.traderonline.com> - Boats, RVs,
Collector Cars, Motorcycles and More.