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, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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 www.Employmentguide.com -
Bringing Employers
and Jobseekers Together. |
- [ADMIN] revoke create table from a user [EMAIL PROTECTED]
- Re: [ADMIN] revoke create table from a user Bruno Wolff III
- [EMAIL PROTECTED]