Permission denied for create table

From: "Pascal Tufenkji" <ptufenkji(at)usj(dot)edu(dot)lb>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Permission denied for create table
Date: 2008-11-24 06:50:25
Message-ID: 003401c94e00$ee6235b0$150fa8c0@interne.usj.edu.lb
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello, I'm doing a workshop for my students and I'm teaching them how to
create tables in Postgres.

So I created a database for every student, but I'm facing the following
problem:

sql073751=> CREATE TABLE emp1 (id int);

CREATE TABLE

sql073751=> SELECT * into emp2 from emp;

ERROR: emp: permission denied

sql073751=> CREATE TABLE emp3 as SELECT * from emp;

ERROR: emp: permission denied

Creating a normal table works fine, but creating a table with subqueries is
giving me "permission denied"

Anyone got a clue?

P.S. I'm working on PostgreSQL 7.3.2

Thx

Pascal

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marcin Stępnicki 2008-11-24 07:17:21 Re: Permission denied for create table
Previous Message John DeSoi 2008-11-22 15:48:11 Re: simple text parsing function