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. - Ken
Start Free Trial