Re: [GENERAL] table protections? - Mailing list pgsql-general

From Oleg Broytmann
Subject Re: [GENERAL] table protections?
Date
Msg-id Pine.SOL2.3.96.SK.981126124226.20861C-100000@sun.med.ru
Whole thread Raw
In response to table protections?  ("Gilley, Charles H." <Charles.Gilley@glenayre.com>)
List pgsql-general
Hello!

On Wed, 25 Nov 1998, Gilley, Charles H. wrote:
> Okay, trying to turn on web access to my table.  Pending some changes
> to the pg_hba.conf file, I have the following on my tables:
>
>  +------------------+----------------------------------------------------+
>  |  Relation        |             Grant/Revoke Permissions |
>  +------------------+----------------------------------------------------+
>  | tblauthors       | {"=","www=r"}                                      |
>  ~                  ~                                                    ~
>  | tbltopics        | {"=","www=r"}                                      |
>  +------------------+----------------------------------------------------+
>
> Note the first "=" in the permissions.  What does this mean - that
> public has no access?  Also, how is the owner dealt with in the
> permissions?

   Yes , it means no public access.
   Owner? Very imple - you have no access too!

   When you create a table, you have full access to it. But once you run
GRANT -what- ON table TO www
you loose all you rights. You should include yourself into GRANT:
GRANT -what- ON table TO myself.

Oleg.
----
    Oleg Broytmann  National Research Surgery Centre  http://sun.med.ru/~phd/
           Programmers don't die, they just GOSUB without RETURN.


pgsql-general by date:

Previous
From: "PAX!"
Date:
Subject: Re: [GENERAL] Aggregates and Joins
Next
From: tolik@icomm.ru (Anatoly K. Lasareff)
Date:
Subject: Problem with PlPgsql function on composite types