So I'm adding layers to QGIS from Postgresql, is there a way to "lock" certain layers and make sure that users don't accidentally move stuff around or delete them?

Ideally something done on the project level would be ideal but if it can't be done then how to prevent it from the db?

1 Answer 1


Create a new user in PostGIS and give only SELECT rights. By this way, users can't edit the layer.

Or, in the QGIS project properties, on Identify layers, check the layers to lock (read only). But users could deactivate this.

  • Thanks. We are changing DBs so and adding a bunch of users so we'll leave that until then. Have to wait a few mins to give you the green tick
    – Luffydude
    Commented Jul 26, 2018 at 13:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.