Skip site navigation (1) Skip section navigation (2)

Superuser lacking privs

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 (view raw or flat)
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.

Responses

pgsql-novice by date

Next:From: Urs Rau (UK)Date: 2010-05-06 08:05:19
Subject: Re: how to continue after error in batch mode with psql
Previous:From: Torralba, JorgeDate: 2010-05-05 23:22:40
Subject: superuser lacking privs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group