Thread: permissions in PgSQL 7.2.1

Hi

I have a problem with permissions. I have a user admin1. His permissions are
select, insert, update and delete on table employee.
After connecting with this user, I tried to create a table, and it worked.
Why does this work? I don't want, that admin1 can create tables.
Before I gave admin1 the permissions, I revoked all.
Thanks for your answers.

CU Roger

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A permission for users creating tables is in TODO list.

http://developer.postgresql.org/todo.php

> After connecting with this user, I tried to create a table, and it worked.
> Why does this work? I don't want, that admin1 can create tables.

Hiroki

- --
 ----------------------------------------------------
    Hiroki Takada <takada@rh.xdsl.ne.jp>

    My public key is available at the public key
    servers. The message was signed as iso-2022-jp
    char-set document in no PGP/MINE (RFC 2015)
    format.
 ----------------------------------------------------


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: KUHASIKU WA http://www.gnupg.org/ WO GORANKUDASAI

iD8DBQE9I7ZOyTl8Jc+E3sERAiRkAJ9ve+NseQtYezNIzyE0XfnWAgIQwgCfXwN6
I/DOoTEtie3txXhZSkhdmD0=
=CLN3
-----END PGP SIGNATURE-----