Latest Contributions by JamesMorrison1

Hello Marcelo As always great and in-depth replies. Much appreciated. [1] So I create the Role in Oracle backup_data_read_role [2] I then use three sde connection files for AREA1, AREA2 and AREA3 to give access to data owned in each separate Schema. [3] In ArcGIS Pro / Arcpy for each separate sde connection file I can do the following: AREA1.sde arcpy.management.ChangePrivileges(FC1, " backup_data_read_role", "GRANT") arcpy.management.ChangePrivileges(TAB1, " backup_data_read_role", "GRANT") AREA2.sde arcpy.management.ChangePrivileges(FC1, " backup_data_read_role", "GRANT") arcpy.management.ChangePrivileges(FC2, " backup_data_read_role", "GRANT") arcpy.management.ChangePrivileges(TAB1, " backup_data_read_role", "GRANT") AREA3.sde arcpy.management.ChangePrivileges(FC1, " backup_data_read_role", "GRANT") arcpy.management.ChangePrivileges(FC2, " backup_data_read_role", "GRANT") arcpy.management.ChangePrivileges(TAB1, " backup_data_read_role", "GRANT") arcpy.management.ChangePrivileges(TAB2, " backup_data_read_role", "GRANT") Finally assign Role backup_data_read_role to User BACKUP_DB in Oracle [4] Create sde connection file for BACKUP_DB and this User should be able to see data in all three Schema AREA1, AREA2 and AREA3 via the backup_data_read_role?

Hello Everyone. Oracle 19c / ArcGIS Pro 3.2 / eGDB 11.1 I wish to have one sde connection file to have read-only access to data across multiple schema to export them via arcpy to a fGDB. With the aim to make a nightly export. I have read the documentation: Grant and revoke dataset privileges in databases and enterprise geodatabases—ArcGIS Pro | Documentation Basically I want one role to rule them all 🙂 Note: Not our real database structure. AREA1 - user / schema FC1 TAB1 AREA2 - user / schema FC1 FC2 TAB1 AREA3- user / schema FC1 FC2 TAB1 TAB2 Question 1 Can I just create a User BACKUP_DB, create a Role backup_data_read_role. Then assign that Role to each Feature Class (FC) or Table (TAB) in each Schema. Then have just one .sde connection file connecting as BACKUP_DB / PW to be used in my arcpy script? Question 2 I assume I have to login to each Schema separately AREA1, AREA2, AREA3 and assign the Feature Classes and Tables to the Role backup_data_read_role? Can you in the ESRI world assign a Role to data in different Schema? Question 3 Is there a better approach to achieve my results? Feedback appreciated. Before I make too many mistakes 🙂

‎02-28-2024

Great detailed answer Marcelo. Much appreciated. I was only going to use the Alter Field GP Tool never directly with SQL.

‎02-28-2024

Hello DM'ers Geodatabase 11.1 ArcGIS Pro 3.1 Oracle 19.16.0.0 ST_GEOMETRY I have read the documentation on Alter Field as I wish to increase the length of a text field from 100 to 200 characters. The field contains data already and the feature class is editable and so has associated A and D tables. Firstly, is it possible to use the alter field tool on feature classes stored in Oracle to increase field length? Secondly, if it is possible, will the associated A-Table be updated as well? Feedback welcome - thanks.

‎09-07-2023

AWJ - we have used all SDE versions 8, 9.x, 10.x now 11.x over the years and we always experienced old connections. Since this a Test system the Developers are often changing the data model and so the old connections stop them. Hence my original question posted below. Thank you for your feedback. However, my post this time was more on the question: Can a User disconnect their own locks or is this just the job of the SDE User as the geodatabase administrator?

‎09-07-2023

No.

‎09-06-2023

Thank you very much for your feedback AWJ. >> You could grant these to the user directly in Oracle - please consider the impact of this though and test it to see if its your desired outcome. What impacts are you alluding to here? >> I'd be asking why these locks are being held and turning into "old locks" - are you using feature datasets in your Enterprise geodatabase? No Feature Datasets. Just Feature Classes. Since I started with Oracle / SDE way back in 2004 we have always encountered these old connections. Never really found a reason for them.....we just killed them via a script run at night. So one editing. Thanks.

‎09-06-2023

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.htm#:~:text=resource%20for%20use.-,Note%3A,pane%20and%20click%20Administration%20%3E%20Locks. 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.

‎08-11-2023

Thanks Vince for the feedback. After running Oracle for close on 20 years I'll have to get up to speed with PostgreSQL .

‎08-10-2023

Hello Everyone. Sorry to ask a very general question like how long is a piece of string. In the coming months we will open talks with our IT department who currently host our Oracle databases with the aim to migrate to PostgreSQL. This will be perhaps be a 1 to 2 year goal to complete. From your own experiences are there any general issues which we should address with the IT department and any issues ArcGIS Pro clients may have? For example - lyrx files created pointing at Oracle will no longer work when pointing at PostgreSQL? Thank you very much for your feedback.

‎05-22-2023

Thank you George - so I assume the sde.gdb_util.update_open_cursors stored procedure updates the open_cursors parameter - no direct SQL.

‎05-22-2023

Hello Everyone After reading the following article...we use Oracle 19c... Update open_cursors setting in geodatabases in Oracle—ArcGIS Pro | Documentation The sde.gdb_util.update_open_cursors stored procedure updates the open_cursors parameter stored in the sde geodatabase repository [Q1] In which SDE Repository Table is the open_cursors parameter stored? Thanks.

‎05-10-2023

Perfect thanks Marcelo. Appreciated.

‎05-10-2023

Hi Marcelo. Thank you for the feedback. I assumed there would be some difference between ARcGIS Pro versions. However my question was directed at the Linux version: 11MB to 42MB. whereas the other flavours windows, sun etc only changed by 1MB or so. To me this seems a major update and if my size figures are correct I was querying why.

‎05-10-2023

Hi Chris Thanks for the tip. It seems the files we downloaded are correct. So can you explain the difference in file size for the Linux version?

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by JamesMorrison1

Re: One Role to back up data with arcpy across multiple Schema in Oracle

One Role to back up data with arcpy across multiple Schema in Oracle

Re: Oracle: Increase field text length on feature class with A and D Tables.

Oracle: Increase field text length on feature class with A and D Tables.

Re: Manage geodatabase locks…but not as the SDE geodatabase administrator – Possible?

Re: Manage geodatabase locks…but not as the SDE geodatabase administrator – Possible?

Re: Manage geodatabase locks…but not as the SDE geodatabase administrator – Possible?

Manage geodatabase locks…but not as the SDE geodatabase administrator – Possible?

Re: Moving from Oracle to PostgreSQL eGDB - kick off points

Moving from Oracle to PostgreSQL eGDB - kick off points

Re: sde.gdb_util.update_open_cursors - open_cursors parameter

sde.gdb_util.update_open_cursors - open_cursors parameter

Re: Oracle Linux64 libst_shapelib.so file size: ArcGISPro 3.0 to ArcGISPro 3.1

Re: Oracle Linux64 libst_shapelib.so file size: ArcGISPro 3.0 to ArcGISPro 3.1

Re: Oracle Linux64 libst_shapelib.so file size: ArcGISPro 3.0 to ArcGISPro 3.1

sde.gdb_util.update_open_cursors - open_cursors pa...

Attribute Index name changes when loaded data from...

Re: Oracle and Geodatabase Migration (18.6 - 19.6 ...

Re: Oracle: upgrade libst_shapelib.so or the geoda...

Geometry check options on web editing with data in...