Postgres Pro
Downloads
Home   >   mailing lists

read-only databases - Mailing list pgsql-general

From Dmitry Morozovsky
Subject read-only databases
Date
Msg-id Pine.BSF.3.96.990801192058.11423U-100000@woozle.rinet.ru
Whole thread Raw
List pgsql-general
Tree view 
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-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] Problem with a GROUP BY clause
Next
From: "Robert J. Sprawls"
Date:
Subject: Re: [ADMIN] Install problems (libpq.so.1)