Permission denied for create table - Mailing list pgsql-sql

From Pascal Tufenkji
Subject Permission denied for create table
Date
Msg-id 003401c94e00$ee6235b0$150fa8c0@interne.usj.edu.lb
Whole thread Raw
Responses Re: Permission denied for create table
Re: Permission denied for create table
Re: Permission denied for create table
List pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Hello, I’m doing a workshop for my students and I’m teaching them how to create tables in
Postgres.</span></font><pclass="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; 
font-family:Verdana">So I created a database for every student, but I’m facing the following problem:</span></font><p
class="MsoNormal"><fontface="Verdana" size="2"><span style="font-size:10.0pt; 
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">sql073751=> CREATE TABLE emp1 (id int);</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">CREATE TABLE</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">sql073751=> SELECT * into emp2 from emp;</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">ERROR:  emp: permission denied</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">sql073751=> CREATE TABLE emp3 as SELECT * from emp;</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">ERROR:  emp: permission denied</span></font><p class="MsoNormal"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Creating a normal table works fine, but creating a table with subqueries is giving me “permission
denied”</span></font><pclass="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; 
font-family:Verdana">Anyone got a clue?</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size:10.0pt;
font-family:Verdana">P.S. I’m working on PostgreSQL 7.3.2</span></font><p class="MsoNormal"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Thx </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size:10.0pt;
font-family:Verdana">Pascal</span></font></div>

pgsql-sql by date:

Previous
From: John DeSoi
Date:
Subject: Re: simple text parsing function
Next
From: "Marcin Stępnicki"
Date:
Subject: Re: Permission denied for create table