Advertisement

04.08.2005 at 08:18AM PDT, ID: 21381739
[x]
Attachment Details

Permission denied for relation, Can't view newly created table in Webmin

Asked by kenalexander321 in PostgreSQL Database

Tags: denied, permission, relation

I received some SQL commands to execute in order to create tables for a report that my Director is wanting.  I executed the commands in Webmin on the server and I cannot see the tables it created.  When I go to the report and set location in Crystal Reports, I can see the tables there and set the location. When I run the report I receive the error " ODBC error: ERROR: permission denied for relation (table name)".  The tables are owned by public. The same thing happens in Access.  I have tried changing my ODBC connection settings.  It seems like it might need to change some "granted privileges" but I can't see the tables to do so.  Any help would be appreciated. - KenStart Free Trial
[+][-]04.08.2005 at 10:09AM PDT, ID: 13738396

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.08.2005 at 02:25PM PDT, ID: 13740766

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: PostgreSQL Database
Tags: denied, permission, relation
Sign Up Now!
Solution Provided By: earthman2
Participating Experts: 1
Solution Grade: A
 
 
[+][-]04.08.2005 at 02:55PM PDT, ID: 13740964

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32