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


From: "Alexei E(dot) Korneyev" <alexei(at)niva(dot)sposad(dot)ru>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: bugs
Date: 2000-08-31 19:46:03
Message-ID: 002c01c01384$197e6ae0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
                        POSTGRESQL BUG REPORT TEMPLATE

Your name               : Alexei E. Korneyev
Your email address      : alexei(at)niva(dot)sposad(dot)ru

System Configuration
  Architecture     : Intel Pentium II

  Operating System : Linux RedHat 2.2.12

  PostgreSQL version :   PostgreSQL-7.0.2

  Compiler used : uncnown Build Host:

Please enter a FULL description of your problem:
i create this:

create table "users" (
    name        varchar(10) PRIMARY KEY
create table "stat" (
    peername    varchar(10) REFERENCES users(name)

revoke ALL on stat,users from PUBLIC;
grant INSERT, SELECT on stat to statist;
grant select on users to statist;
grant ALL on stat to basemaster;
insert into users values('niva');
insert into stat values ('niva',abstime('now'),timespan(0),8607272,1829436);
After that I do(make) connection as the user statis and execute cmd:
insert into stat
values('niva',abstime('now'),timespan(abstime('now')-(select max(timewrite)
from stat)),50,50);";
server say:Access deny on users...

After I change the rights on:

grant select,update on users to statist;

,the query exec successfully

Alexei E. Korneyev


  • Re: bugs at 2000-09-06 16:35:42 from Stephan Szabo

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-08-31 23:56:53
Subject: Responses to bugs should appear publically with bug reports
Previous:From: pgsql-bugsDate: 2000-08-31 00:08:42
Subject: misleading (or perhaps confusing) error messages

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