From: | Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Superuser lacking privs |
Date: | 2010-05-05 23:26:19 |
Message-ID: | x2ka15153391005051626me0046eb1hd8076093938c2f5b@mail.gmail.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
--
Thanks,
Jorge Torralba
----------------------------
Note: This communication may contain privileged or other confidential
information. If you are not the intended recipient, please do not print,
copy, retransmit, disseminate or otherwise use the information. Please
indicate to the sender that you have received this email in error and delete
the copy you received. Thank You.
From | Date | Subject | |
---|---|---|---|
Next Message | Urs Rau (UK) | 2010-05-06 08:05:19 | Re: how to continue after error in batch mode with psql |
Previous Message | Torralba, Jorge | 2010-05-05 23:22:40 | superuser lacking privs |