superuser lacking privs

From: "Torralba, Jorge" <Jorge_Torralba(at)adp(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: superuser lacking privs
Date: 2010-05-05 23:22:40
Message-ID: D46B8BC43445C847B1CD33968AF78232585514A336@DSMAIL1HE.ds.ad.adp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am new to Postgres coming from a background in SQL Server, Informix, MySQL and Oracle. However, I am a little confused right now and maybe someone can answer this.

Typically a super user such as SA, mysql, Informix etc ... has rights to all objects in any database. However, we have a database owned by a user (otheruser) and if I log in as superuser postgres and connect to the database in question I cannot see any objects. What am I missing here?

I am logging in then issuing \c dbname

Here are the entries for roles

List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
------------+-----------+-------------+-----------+-------------+------------
postgres | yes | yes | yes | no limit | {}
otheruser | no | no | no | no limit | {siteadmins}
siteadmins | no | no | no | no limit | {}

Thanks for any feedback.

JT

This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system.

Browse pgsql-novice by date

  From Date Subject
Next Message Jorge Torralba 2010-05-05 23:26:19 Superuser lacking privs
Previous Message Atif Jung 2010-05-05 15:54:29 FETCHING into a struct in C