Permission denied for relation tablename

[Sarva Pulla]

I just created a new persistent store and initialized with five rows of data. However, when I check to see if the data was inserted properly into the table, I get the following error: "ERROR:  permission denied for relation censorcodecv". I tried to change privileges manually in pgAdmin and it still shows the same error. I tried to change it in the SQL tab as well. I am trying to create an ODM database in Tethys (http://his.cuahsi.org/images/ODM1_1SchemaDiagram_md.jpg) and there will be several other tables. What do I need to do to ensure that the permissions are fine for the this table and the several tables that I'll be creating for this database? Thank you!!!

[Zhiyu (Drew) Li]

try to login pgadmin as tethys_db_manager or tethys_super, the password is in /usr/lib/tethys/src/tethys_apps/settings.py

On Fri, Jul 1, 2016 at 3:28 PM, Sarva Pulla <sarv...@gmail.com> wrote:

I just created a new persistent store and initialized with five rows of data. However, when I check to see if the data was inserted properly into the table, I get the following error: "ERROR:  permission denied for relation censorcodecv". I tried to change privileges manually in pgAdmin and it still shows the same error. I tried to change it in the SQL tab as well. I am trying to create an ODM database in Tethys (http://his.cuahsi.org/images/ODM1_1SchemaDiagram_md.jpg) and there will be several other tables. What do I need to do to ensure that the permissions are fine for the this table and the several tables that I'll be creating for this database? Thank you!!!

--
You received this message because you are subscribed to the Google Groups "Tethys Platform" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tethysplatfor...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tethysplatform/bc8ef61b-43f3-4ad0-96df-139e714d046b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[swainn]

+1 on zyli2004 response. tethys_default user will not have permission to access the persistent store databases. You need to use either tethys_db_manager or tethys_super user.