Thread: revoke create table from a user

revoke create table from a user

From
"bagley@traderonline.com"
Date:
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 - Bringing Employers and Jobseekers Together.
www.ForRent.com - Nation's Leading Apartment Rental Source.
www.HarmonHomes.com - Your Home Site on the Web.
www.ParenthoodWeb.com - Pregnancy and Parenting Advice, Baby Names and More.
www.Roomsaver.com - 6000+ Lodging Coupons.
www.TraderOnline.com - Boats, RVs, Collector Cars, Motorcycles and More.

 

Re: revoke create table from a user

From
Bruno Wolff III
Date:
On Fri, Nov 07, 2003 at 15:47:50 -0500,
  "bagley@traderonline.com" <bagley@traderonline.com> wrote:
> 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.

Re: revoke create table from a user

From
"bagley@traderonline.com"
Date:
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

Bruno Wolff III wrote:
On Fri, Nov 07, 2003 at 15:47:50 -0500, "bagley@traderonline.com" <bagley@traderonline.com> wrote: 
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
(757) 321-8409 (work)
(757) 343-1768 (cell)

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