REVOKE not working...

From: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
To: pgsql-admin(at)postgresql(dot)org
Subject: REVOKE not working...
Date: 2004-10-20 14:17:10
Message-ID: 41767366.7040305@webehosting.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,
I have created users for which I have restricted access to SELECT
from a set of tables, this works :)
But when I issue a REVOKE CREATE ON DATABASE mydb FROM myuser;
The user can still create tables...I've also issued this command for the
SCHEMA and still no go.

Is this a known problem, if so how can I restrict users from creating
objects in my db?

Thanks,

-Joe

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Weiping 2004-10-20 15:19:25 Re: large dumps won't restore
Previous Message Matt Clark 2004-10-20 05:54:31 Re: NIC to NIC connection