I saw my database and got that it has no owner so probably I deleted my user
of database accidentally. Now is there a way to create owner of already
existing database in postgres.
Snapshot of my command prompt which shows that there is no current Owner of
my database. so I need to create owner for this table.
XYZ=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------------------+-------+-------
public | account_codes | table |
public | accountcodeid | table |
public | attendance | table |
public | attendance_details | table |
public | audit_trail | table |
----- Original Message -----
From: <operationsengineer1@yahoo.com>
To: "Inpreet Singh" <Singh.Inpreet@netsity.com>;
<pgsql-novice@postgresql.org>
Sent: Thursday, January 27, 2005 4:51 AM
Subject: Re: [NOVICE] Postgres database access problem
> inpreet,
>
> i believe the superuser who created the database and
> has all privileges has an id of 1, not 100.
>
> 100 is the id where added users start.
>
> at least that is what happened with my system
> recently.
>
> find the user with id=1. pgadminIII should list the
> id when you click on the user.
>
> good luck.
>
>
>
> --- Inpreet Singh <Singh.Inpreet@netsity.com> wrote:
>
> > Hello,
> >
> > I am using postgres 7.3.4. I am trying to retrieve
> > data from already
> > existing database. I am using postgres, which is
> > super user of my
> > database in php.ini. But when I am trying to
> > retrieve data following
> > error is coming
> > pg_class_aclcheck: invalid user id 100
> >
> > please help me in rectifying this problem.
> >
> > Inpreet Singh
> >
>
>
>
>
> __________________________________
> Do you Yahoo!?
> All your favorites on one personal page - Try My Yahoo!
> http://my.yahoo.com
>
