revoke create table from a user

From: "bagley(at)traderonline(dot)com" <bagley(at)traderonline(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: revoke create table from a user
Date: 2003-11-07 20:47:50
Message-ID: 3FAC04F6.4090802@traderonline.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
(757) 321-8409 (work)
(757) 343-1768 (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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-11-07 20:49:52 Re: Out of buffer error
Previous Message Markus Bertheau 2003-11-07 20:45:06 Re: small table occupies many relpages