Re: [GENERAL] table protections?

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.