Jump to content

[Solved] Cannot access Cpanel (Postgres)


jpsshort

Recommended Posts

Hi

 

I can now remotely access my database jpsshort_cms with user jpsshort_admin.  However, I don't seem to have the ability to add any data to the database.  i was hoping to be able to create users who would have access to creating geometry tables.

 

Your assistance would be appreciated.

Link to comment
Share on other sites

Hi


 


I can now remotely access my database jpsshort_cms with user jpsshort_admin.  However, I don't seem to have the ability to add any data to the database.  i was hoping to be able to create users who would have access to creating geometry tables.


 


When I access this database it states that I have no privileges over any of the tables in the database.


 


Your assistance would be appreciated.

Link to comment
Share on other sites

Looking at the database it is under the public schema which is owned by postgres.  Does postgres need to give me permissions or is there another way to resolve the fact I do not seem to be able to control the database.  I tried to create an additional schema but that just caused the database to fail.  Your help would be appreciated as until I can access the database I cannot do any tests.

Link to comment
Share on other sites

I have created a second test database and note that it is created with the public schema which is controlled by postgres. 

 

I assume that postgres must therefore give any users within that database privileges such as create delete etc.  If this is the case could the jpsshort_cms database with user jpsshort_admin be granted all privileges needed to operate the database please.

Link to comment
Share on other sites

I have had another look at QGIS and it shows the owner of the database as postgres and therefore I have no privileges to access the database.  I would appreciate postgres granting me privileges so I can add point, line and polygon layers to the database jpsshort_cms with user jpsshort_admin.

 

Thanks

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...