Best Practices with Granting Privileges and Versioning Data

[JoshBillings]

Hey all,

I am working on getting a new Oracle enterprise geodatabase set up for our organization. Our named users are using account credentials that utilize our AD. The DBA has a process that he runs to grant privileges to roles and users in the geodatabase. Every time he runs this privilege process, I get a "ORA-00942 table or view does not exist" error when I try to open a table in a map. I have to un-version and re-version the tables in the geodatabase in order to access the tables again with any account other than the data owner. Is there any cause for concern in doing this?

We were handling privileges through ArcMap/Pro in our old database but we thought our DBA's process he created might be better for the new database. How does your organization typically handle granting privileges to users and roles?  

Thanks,

Josh

[JoshBillings]

@MarceloMarques @ShannonShields Thank you for the replies. Would there happen to be a table in the geodatabase that shows all of these A & D tables and what feature class they belong to?

[MarceloMarques]

@JoshBillings - the featureclass registration_id in the sde.table_registry table in the sde repository is used to name the Delta Tables, A<registration_id> Adds Table and D_<registration_id> for Deletes Table.

How to determine the Delta Tables - Adds Table, Deletes Table of a Featureclass or Table registered as traditional versioning.

How to determine the Featureclass ST_Geometry Spatial Index Table

 this other discussion that I provided some examples as well might help further.

Solved: One Role to back up data with arcpy across multipl... - Esri Community