pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
table permissions
11+ messages / 4 participants
[nested] [flat]

* table permissions
@ 2001-10-29 23:23 Oleg Lebedev <olebedev@waterford.org>
  2001-10-29 23:57 ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
  2001-10-30 00:07 ` Re: table permissions Stephan Szabo <sszabo@megazone23.bigpanda.com>
  0 siblings, 2 replies; 11+ messages in thread

From: Oleg Lebedev @ 2001-10-29 23:23 UTC (permalink / raw)
  To: pgsql-sql

Hi everybody,
I have a table called 'set' and I am trying to edit or insert an entry
there. I made sure that I have ALL permissions to modify that table, but
still I get the same error:
ERROR: activity: Permission denied.

I don't know where 'activity' part came from, but there is a reference
to activity table in set table.
I know this is a very vague descritption of the symptoms, but I don't
know where to look to find out more info. I'll happily provide any
further details.
thanks,

Oleg




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: table permissions
  2001-10-29 23:23 table permissions Oleg Lebedev <olebedev@waterford.org>
@ 2001-10-29 23:57 ` Aasmund Midttun Godal <postgresql@envisity.com>
  2001-10-30 00:23   ` Re: table permissions Oleg Lebedev <olebedev@waterford.org>
  1 sibling, 1 reply; 11+ messages in thread

From: Aasmund Midttun Godal @ 2001-10-29 23:57 UTC (permalink / raw)
  To: olebedev@waterford.org; +Cc: pgsql-sql

I used to have this problem in earlier  versions of postgres, after I upgraded they disappeared.

Regards,

Aasmund.
On Mon, 29 Oct 2001 16:23:28 -0700, Oleg Lebedev <olebedev@waterford.org> wrote:
> Hi everybody,
> I have a table called 'set' and I am trying to edit or insert an entry
> there. I made sure that I have ALL permissions to modify that table, but
> still I get the same error:
> ERROR: activity: Permission denied.
> 
> I don't know where 'activity' part came from, but there is a reference
> to activity table in set table.
> I know this is a very vague descritption of the symptoms, but I don't
> know where to look to find out more info. I'll happily provide any
> further details.
> thanks,
> 
> Oleg
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: table permissions
  2001-10-29 23:23 table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-10-29 23:57 ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
@ 2001-10-30 00:23   ` Oleg Lebedev <olebedev@waterford.org>
  2001-10-30 00:09     ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
  0 siblings, 1 reply; 11+ messages in thread

From: Oleg Lebedev @ 2001-10-30 00:23 UTC (permalink / raw)
  To: Aasmund Midttun Godal <postgresql@envisity.com>; pgsql-sql

I am using v7.1.2
I guess, this might be a table locking problem, but I don't have any transactions currently running.

A couple of days ago I did a restore of 'set' table from a dump file, and it didn't go too well - I
had a couple of problems. I don't know if it's relevant, but smth's telling me that it is.

Oleg

Aasmund Midttun Godal wrote:

> I used to have this problem in earlier  versions of postgres, after I upgraded they disappeared.
>
> Regards,
>
> Aasmund.
> On Mon, 29 Oct 2001 16:23:28 -0700, Oleg Lebedev <olebedev@waterford.org> wrote:
> > Hi everybody,
> > I have a table called 'set' and I am trying to edit or insert an entry
> > there. I made sure that I have ALL permissions to modify that table, but
> > still I get the same error:
> > ERROR: activity: Permission denied.
> >
> > I don't know where 'activity' part came from, but there is a reference
> > to activity table in set table.
> > I know this is a very vague descritption of the symptoms, but I don't
> > know where to look to find out more info. I'll happily provide any
> > further details.
> > thanks,
> >
> > Oleg
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
> Aasmund Midttun Godal
>
> aasmund@godal.com - http://www.godal.com/
> +47 40 45 20 46




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: table permissions
  2001-10-29 23:23 table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-10-29 23:57 ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
  2001-10-30 00:23   ` Re: table permissions Oleg Lebedev <olebedev@waterford.org>
@ 2001-10-30 00:09     ` Aasmund Midttun Godal <postgresql@envisity.com>
  2001-10-30 00:44       ` Re: table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-10-30 01:00       ` Re: table permissions Oleg Lebedev <olebedev@waterford.org>
  0 siblings, 2 replies; 11+ messages in thread

From: Aasmund Midttun Godal @ 2001-10-30 00:09 UTC (permalink / raw)
  To: olebedev@waterford.org; +Cc: pgsql-sql

The problem is that updating/inserting/deleting a row which references another table requires all permissions on that table. This has been fixed.

Regards,

Aasmund.

On Mon, 29 Oct 2001 17:23:25 -0700, Oleg Lebedev <olebedev@waterford.org> wrote:
> I am using v7.1.2
> I guess, this might be a table locking problem, but I don't have any transactions currently running.
> 
> A couple of days ago I did a restore of 'set' table from a dump file, and it didn't go too well - I
> had a couple of problems. I don't know if it's relevant, but smth's telling me that it is.
> 
> Oleg
> 
> Aasmund Midttun Godal wrote:
> 
> 

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: table permissions
  2001-10-29 23:23 table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-10-29 23:57 ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
  2001-10-30 00:23   ` Re: table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-10-30 00:09     ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
@ 2001-10-30 00:44       ` Oleg Lebedev <olebedev@waterford.org>
  1 sibling, 0 replies; 11+ messages in thread

From: Oleg Lebedev @ 2001-10-30 00:44 UTC (permalink / raw)
  To: Aasmund Midttun Godal <postgresql@envisity.com>; pgsql-sql

I guess it's not fixed in release 7.1.2, since when I added all permissions on the referenced table, it started working.
Do I need to download a new version again (I just did it 2 weeks ago)?
thanks,

Aasmund Midttun Godal wrote:

> The problem is that updating/inserting/deleting a row which references another table requires all permissions on that table. This has been fixed.
>
> Regards,
>
> Aasmund.
>
> On Mon, 29 Oct 2001 17:23:25 -0700, Oleg Lebedev <olebedev@waterford.org> wrote:
> > I am using v7.1.2
> > I guess, this might be a table locking problem, but I don't have any transactions currently running.
> >
> > A couple of days ago I did a restore of 'set' table from a dump file, and it didn't go too well - I
> > had a couple of problems. I don't know if it's relevant, but smth's telling me that it is.
> >
> > Oleg
> >
> > Aasmund Midttun Godal wrote:
> >
> >
>
> Aasmund Midttun Godal
>
> aasmund@godal.com - http://www.godal.com/
> +47 40 45 20 46




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: table permissions
  2001-10-29 23:23 table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-10-29 23:57 ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
  2001-10-30 00:23   ` Re: table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-10-30 00:09     ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
@ 2001-10-30 01:00       ` Oleg Lebedev <olebedev@waterford.org>
  2001-10-30 03:20         ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
  1 sibling, 1 reply; 11+ messages in thread

From: Oleg Lebedev @ 2001-10-30 01:00 UTC (permalink / raw)
  To: Aasmund Midttun Godal <postgresql@envisity.com>; +Cc: pgsql-sql

I have 3 users in the database: postgres, oleg, and boss. boss is the superuser and has permissions to modify both original and referenced table.
However, when I am logged in as boss, it won't let me modify the original ('set') table unless user oleg (!!!!) has update permissions on the
referenced table ('activity'). Now I understand that I didn't have this problem before, because I just recently created this superuser boss.

Another thing, I just noticed is that the tables I mentioned do not have permissions defined for user postgres. All the other tables in my database
do have those permissions set. Can this be the cause of the problem?
thanks,

Oleg

Aasmund Midttun Godal wrote:

> The problem is that updating/inserting/deleting a row which references another table requires all permissions on that table. This has been fixed.
>
> Regards,
>
> Aasmund.
>
> On Mon, 29 Oct 2001 17:23:25 -0700, Oleg Lebedev <olebedev@waterford.org> wrote:
> > I am using v7.1.2
> > I guess, this might be a table locking problem, but I don't have any transactions currently running.
> >
> > A couple of days ago I did a restore of 'set' table from a dump file, and it didn't go too well - I
> > had a couple of problems. I don't know if it's relevant, but smth's telling me that it is.
> >
> > Oleg
> >
> > Aasmund Midttun Godal wrote:
> >
> >
>
> Aasmund Midttun Godal
>
> aasmund@godal.com - http://www.godal.com/
> +47 40 45 20 46




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: table permissions
  2001-10-29 23:23 table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-10-29 23:57 ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
  2001-10-30 00:23   ` Re: table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-10-30 00:09     ` Re: table permissions Aasmund Midttun Godal <postgresql@envisity.com>
  2001-10-30 01:00       ` Re: table permissions Oleg Lebedev <olebedev@waterford.org>
@ 2001-10-30 03:20         ` Aasmund Midttun Godal <postgresql@envisity.com>
  0 siblings, 0 replies; 11+ messages in thread

From: Aasmund Midttun Godal @ 2001-10-30 03:20 UTC (permalink / raw)
  To: olebedev@waterford.org; +Cc: pgsql-sql

I don't really know a lot about these issues. However another problem I used to have (I have just avoided it for the time being, and I am getting back to it!) is corrupted users, have you messed around with pg_hba.conf? perhaps it is a problem with this.

I apologize, but I don't really know. Hope someone else can help you!

Regards,

Aasmund.

On Mon, 29 Oct 2001 18:00:42 -0700, Oleg Lebedev <olebedev@waterford.org> wrote:
> I have 3 users in the database: postgres, oleg, and boss. boss is the superuser and has permissions to modify both original and referenced table.
> However, when I am logged in as boss, it won't let me modify the original ('set') table unless user oleg (!!!!) has update permissions on the
> referenced table ('activity'). Now I understand that I didn't have this problem before, because I just recently created this superuser boss.
> 
> Another thing, I just noticed is that the tables I mentioned do not have permissions defined for user postgres. All the other tables in my database
> do have those permissions set. Can this be the cause of the problem?
> thanks,
> 
> Oleg
> 
> Aasmund Midttun Godal wrote:
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: table permissions
  2001-10-29 23:23 table permissions Oleg Lebedev <olebedev@waterford.org>
@ 2001-10-30 00:07 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
  1 sibling, 0 replies; 11+ messages in thread

From: Stephan Szabo @ 2001-10-30 00:07 UTC (permalink / raw)
  To: Oleg Lebedev <olebedev@waterford.org>; +Cc: pgsql-sql


On Mon, 29 Oct 2001, Oleg Lebedev wrote:

> Hi everybody,
> I have a table called 'set' and I am trying to edit or insert an entry
> there. I made sure that I have ALL permissions to modify that table, but
> still I get the same error:
> ERROR: activity: Permission denied.
>
> I don't know where 'activity' part came from, but there is a reference
> to activity table in set table.
> I know this is a very vague descritption of the symptoms, but I don't
> know where to look to find out more info. I'll happily provide any
> further details.

What version of postgres are you running?  I know that at one point we had
a problem with requiring select & update permissions to the primary key
table referenced by a foreign key.





^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* table permissions
@ 2001-11-01 21:04 Oleg Lebedev <olebedev@waterford.org>
  2001-11-01 22:35 ` Re: table permissions Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 11+ messages in thread

From: Oleg Lebedev @ 2001-11-01 21:04 UTC (permalink / raw)
  To: pgsql-sql

Hi everybody,
I can't seem to figure this one out.
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.
Does anybody know how to solve this problem?
Should I upgrade my PostgreSQL version? I am currently using v 7.1.2
thanks,

Oleg




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: table permissions
  2001-11-01 21:04 table permissions Oleg Lebedev <olebedev@waterford.org>
@ 2001-11-01 22:35 ` Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-01 23:13   ` Re: table permissions Oleg Lebedev <olebedev@waterford.org>
  0 siblings, 1 reply; 11+ messages in thread

From: Tom Lane @ 2001-11-01 22:35 UTC (permalink / raw)
  To: Oleg Lebedev <olebedev@waterford.org>; +Cc: pgsql-sql

Oleg Lebedev <olebedev@waterford.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



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: table permissions
  2001-11-01 21:04 table permissions Oleg Lebedev <olebedev@waterford.org>
  2001-11-01 22:35 ` Re: table permissions Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-01 23:13   ` Oleg Lebedev <olebedev@waterford.org>
  0 siblings, 0 replies; 11+ messages in thread

From: Oleg Lebedev @ 2001-11-01 23:13 UTC (permalink / raw)
  To: 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@waterford.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




^ permalink  raw  reply  [nested|flat] 11+ messages in thread


end of thread, other threads:[~2001-11-01 23:13 UTC | newest]

Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-10-29 23:23 table permissions Oleg Lebedev <olebedev@waterford.org>
2001-10-29 23:57 ` Aasmund Midttun Godal <postgresql@envisity.com>
2001-10-30 00:23   ` Oleg Lebedev <olebedev@waterford.org>
2001-10-30 00:09     ` Aasmund Midttun Godal <postgresql@envisity.com>
2001-10-30 00:44       ` Oleg Lebedev <olebedev@waterford.org>
2001-10-30 01:00       ` Oleg Lebedev <olebedev@waterford.org>
2001-10-30 03:20         ` Aasmund Midttun Godal <postgresql@envisity.com>
2001-10-30 00:07 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-01 21:04 table permissions Oleg Lebedev <olebedev@waterford.org>
2001-11-01 22:35 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-01 23:13   ` Oleg Lebedev <olebedev@waterford.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox