"Pascal Tufenkji" <ptufenkji(at)usj(dot)edu(dot)lb> writes:
> Creating a normal table works fine, but creating a table with subqueries is
> giving me "permission denied"
You need to explicitly grant select permission on the child tables not
just the parent.
> P.S. I'm working on PostgreSQL 7.3.2
As already noted, you really ought to update that ... among other
things, the documentation in recent versions explicitly covers the
point above ;-)
regards, tom lane
In response to
pgsql-sql by date
|Next:||From: Tk421||Date: 2008-11-24 19:12:12|
|Subject: Sequence and nextval problem|
|Previous:||From: Richard Huxton||Date: 2008-11-24 09:24:13|
|Subject: Re: Permission denied for create table|