Removing {"="} privledges

From: "Robert Fitzpatrick" <robert(at)webtent(dot)com>
To: "PostgreSQL Users" <pgsql-general(at)postgresql(dot)org>
Subject: Removing {"="} privledges
Date: 2002-10-12 17:05:20
Message-ID: 200210121705.g9CH5KG04179@hermes.webtent.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have a Cobalt RaQ4r that uses Postgres as the back-end of it's
management GUI. I created a Postgres user and gave the user privledges
(SELECT only) to the Cobalt database so I could read information into
a web app of our own. When I did this, it added the {"="} privledge to
that database privledges for all tables and I started having problems
with the GUI. I had to add the 'admin' (pre-defined Cobalt user) with
all privledges to get the problems in the GUI to go away. This is what
it made the privledges look like:

Access permissions for database "cobalt"
Relation | Access permissions
----------+--------------------
bw | {"=","admin=arwR"}
cpu | {"="}
defcon | {"="}
memory | {"="}
network | {"="}
quota | {"="}
service | {"="}
users | {"=","admin=arwR"}
vsite | {"=","admin=arwR"}

With these privledges, some parts of the Cobalt GUI are not operating
properly. I looked at another Cobalt RaQ we have where the problem
does not exist and no changes were made, it looks like this:

Access permissions for database "cobalt"
Relation | Access permissions
----------+--------------------
bw | {"=","admin=arwR"}
cpu |
defcon |
memory |
network |
quota |
service |
users | {"=","admin=arwR"}
vsite | {"=","admin=arwR"}

I want to get the privledges back on the first server to what is on
the second server. If I look in my phpPgAdmin, it shows a public user
with no privledges on all tables in the database, I am assuming this
is what is making the {"="} privledge show up. I tried 'revoke all on
defcon from public;', but the privledge remains for that table. Right
now, the privledges are like below, but I'd rather get them back to
the way it is shown in the last listing above, any help? As you can
tell, I'm pretty new at Postgres.

Access permissions for database "cobalt"
Relation | Access permissions
------------+--------------------------------
bw | {"=","admin=arwR"}
cpu | {"=","admin=arwR"}
defcon | {"=","admin=arwR"}
grpquota | {"=","admin=arwR"}
memory | {"=","admin=arwR"}
network | {"=","admin=arwR"}
quota | {"=","admin=arwR"}
service | {"=","admin=arwR"}
users | {"=","admin=arwR"}
usrquota | {"=","admin=arwR"}
vsite | {"=","admin=arwR"}

--
Thanks:)

Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darko Prenosil 2002-10-12 18:58:53 Re: [HACKERS] MySQL vs PostgreSQL.
Previous Message Justin Clift 2002-10-12 16:42:56 Re: certified installer/administrator