[GENERAL] read-only databases - Mailing list pgsql-hackers

From Oleg Broytmann
Subject [GENERAL] read-only databases
Date
Msg-id Pine.LNX.4.04.9908021637360.11722-100000@emerald.netskate.ru
Whole thread Raw
List pgsql-hackers
Hi!
  We've discussed the issue and got to conclusion - Postgres needs to
implement more granulated rights. Currently user after connecting to DB can
do almost anything, at least she can create its own tables and do whatever
she wants.
  I want to compare the situation to MySQL. In this field MySQL design is
better than ours - in MySQL database admin can grant and revoke a lot of
rights for given DB - who can connect and from which host, who can CREATE
TABLEs, INSERT, UPDATE, DELETE, DROP and all that...

Oleg.
----    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net          Programmers don't die, they
justGOSUB without RETURN.
 

---------- Forwarded message ----------
Date: Sun, 1 Aug 1999 19:23:20 +0400 (MSD)
From: Dmitry Morozovsky <marck@rinet.ru>
To: pgsql-general@postgreSQL.org
Subject: [GENERAL] read-only databases

Hello there again.

Is there a way to make database 'db' for user 'john' read-only? I mean, is
there a way to disable 'create table/index/etc' SQL statements? I can make
read-only restrictions on existing tables, but -- what about creating new?

PgSQL 6.5, surely. Thanx in advance.

Sincerely,
D.Marck                                   [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
------------------------------------------------------------------------





pgsql-hackers by date:

Previous
From: Oleg Broytmann
Date:
Subject: [GENERAL] database access authentication: crypted passwords
Next
From: "John Ridout"
Date:
Subject: RE: [HACKERS] Optimizer hints