On Tue, May 29, 2001 at 07:49:46PM -0400, Arcadio A. Sincero Jr. wrote:
> Hello list,
wrong list. try pgsql-general@postgresql.org instead.
> I'd like to set up Postgresql so that users can have "read-only" access to a
> database. Right now, I only know how to set it so a user can have all or
>
> I'd like to set up Postgresql so that users can have "read-only" access to a
> database.
To keep users from creating new tables, how about altering the permissions on
the pg_class system table? This table is part of the system catalog, it keeps
a list of all tables. If a user doesn't have pe
On Tue, May 29, 2001 at 08:12:57PM -0400, Arcadio A. Sincero Jr. wrote:
> But that only defines permissions on the individual tables of the database.
> I'm trying to set permissions on the database itself. Specifically I'm
> trying to prevent users from being able to do CREATE TABLE but still be a
m: "Andrew Perrin" <[EMAIL PROTECTED]>
To: "Arcadio A. Sincero Jr." <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 29, 2001 8:58 PM
Subject: Re: *** Newbie Question About PostgreSQL ***
> You should look through the PostgreSQL documentation. But basically, you
>
You should look through the PostgreSQL documentation. But basically, you
manage users using SQL:
CREATE USER foo WITH PASSWORD bar;
GRANT READ ON table TO foo;
REVOKE DELETE ON table FROM foo;
--
Andrew J Perrin - [EMAIL PROTECTE
Hello list,
I'd like to set up Postgresql so that users can have "read-only" access to a
database. Right now, I only know how to set it so a user can have all or
nothing access by adding something like the following in the pg_hba.conf
file:
localmydbcryptusers.mydb
And put the names
6 matches
Mail list logo
