From: | Oleg Lebedev <olebedev(at)waterford(dot)org> |
---|---|
To: | Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: table permissions |
Date: | 2001-11-01 23:13:23 |
Message-ID: | 3BE1D713.71B98EC3@waterford.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Tom,
you were right, some of the tables were owned by oleg. I changed it and now it
works fine.
So, in order for the table to be updated successfully, it's owner and updating
user must have permissions to do that, right?
thanks a lot,
Oleg
Tom Lane wrote:
> Oleg Lebedev <olebedev(at)waterford(dot)org> writes:
> > I have a superuser root and a regular user oleg. I am trying to insert a
> > new row in table Set, which references table Activity, being logged in
> > as root. I get an error saying:
> > activity: Permission denied.
> > This is very weird because root has all the permissions on every table
> > in the database. Even more strange is that as soon as I grant DELETE
> > privilege to user oleg, the problem disappears and I can add a row to
> > the Set table.
>
> Evidently the update is being done under privileges of user oleg.
> Are you using a view, rule, function, trigger, etc somewhere in there?
> I doubt this would happen with a straightforward INSERT typed at the
> command line, but if the insert command is in a rule or function owned
> by oleg, the game is different ...
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bhuvan A | 2001-11-02 02:56:33 | SELECT statement during transaction |
Previous Message | Tom Lane | 2001-11-01 22:35:07 | Re: table permissions |