permissions in PgSQL 7.2.1

Started by Roger Mathisalmost 24 years ago2 messagesgeneral
Jump to latest
#1Roger Mathis
traderx@gmx.ch

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

#2Hiroki Takada
takada@rh.xdsl.ne.jp
In reply to: Roger Mathis (#1)
Re: permissions in PgSQL 7.2.1

-----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-----