Hello Data Managers
Linux / Oracle 19c / Geodatabase 11.1 / ST_GEOMERTY - not real Schema just for this example: SDE, FORESTS, RIVERS, LAKES.
On our Test Database the Schema FORESTS holds several Feature Classes. These can have old locks on them. So when we try and add a Field to a Feature Class it is not possible due to locks. Or if we want to drop the Feature Class it is not possible due to locks.
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/manage-geodatabase-locks.ht....
Naturally, we can drop the locks as the SDE User.
Right-click the database connection in the Catalog pane and click Administration > Locks. Right-click the database connection in the Catalog pane and click Administration > Locks. The geodatabase administrator requires elevated privileges to disconnect users. ALTER SYSTEM SELECT_CATALOG_ROLE*
Is it possible to assign these two Privilege to the User FORESTS so they can delete their own older connections? I have the feeling this is not possible?
Can a User disconnect their own locks or is this just the job of the SDE User as the geodatabase administrator?
Feedback welcome.