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

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 (view raw or flat)
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

pgsql-sql by date

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

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