Jump to content


Photo

[Solved] Remote DB Schema Access


  • Please log in to reply
3 replies to this topic

#1 Horus

Horus

    Rank I Member

  • Members
  • Pip
  • 14 posts

Posted 29 November 2019 - 07:33 PM

I have been granted remove access to my database. However, it seems the permission also needs to be granted on the schemas as I am not able to access them.

 

Database: gbanhudo@geometries

User: gbanhudo_remoteuser

Schemas: - public

                 - wof

 

 

Thank you!

 

 



#2 Luigi123

Luigi123

    Rank X Member

  • Moderators
  • 1,890 posts
  • Gender:Male
  • Location:Winnipeg, Manitoba, Canada

Posted 29 November 2019 - 10:14 PM

This support request is being escalated to our root admin.
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#3 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 19,175 posts
  • Gender:Male

Posted 02 December 2019 - 01:34 AM

You can grant postgresql permissions yourself through the button labeled PostgreSQL Databases in cPanel.

#4 Horus

Horus

    Rank I Member

  • Members
  • Pip
  • 14 posts

Posted 02 December 2019 - 12:38 PM

This support request is being escalated to our root admin.

 

 

You can grant postgresql permissions yourself through the button labeled PostgreSQL Databases in cPanel.

 

Unfortunately this is not true for Schemas, as for some reason custom schemas other than public reflect in unauthorized remote access. Here is an example on this situation. Is my alternative using the public schema?






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users