I have a few vector layers in a PostGIS database. I want to give the other users of the database read access to these layers. I don't want them to be able to alter them, though. Instead, if anybody wants to make their personal adjustments, they should create their personal copy, of which they are the owner. In PostgreSQL,
CREATE TABLE personal_table as public_table;
Does what I want. Of course, this can also be done from the DBManager.
Is there any other way to accomplish that within the GUI of QGIS 3.4 for users, who are not comfortable with learning code commands?
Usually, the users drag and drop the layers they need from the PostGIS menu in the browser. Right click==>duplicate only creates a copy of the layer in the project but doesn't create a new table with ownership, so the user cannot edit.