jpsshort Posted February 26, 2021 Author Posted February 26, 2021 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.
jpsshort Posted February 27, 2021 Author Posted February 27, 2021 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.
wolstech Posted February 27, 2021 Posted February 27, 2021 Krydos is the only one who can fix this and he hasn't been online since Thursday. You'll need to wait until he sees this to have it fixed.
jpsshort Posted February 27, 2021 Author Posted February 27, 2021 Thanks for the update. I thought it might have been a stupid error on my part.
jpsshort Posted February 28, 2021 Author Posted February 28, 2021 The only user jpsshort_admin. I have granted all privileges to this user but find that within QGIS the database shows this user to have no privileges to add points lines or polygons etc. Your assistance would be appreciated.
jpsshort Posted February 28, 2021 Author Posted February 28, 2021 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.
jpsshort Posted February 28, 2021 Author Posted February 28, 2021 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.
jpsshort Posted March 1, 2021 Author Posted March 1, 2021 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
Krydos Posted March 2, 2021 Posted March 2, 2021 Have you added the user to the database?If you had added the user to the database it should show it under the privileged users column. Maybe try adding it again?
Recommended Posts