Latest Contributions by Asrujit_SenGupta

Seems to be an issue with the default permissions granted to the PUBLIC role. I have a list of the default permissions granted to the PUBLIC role for an sde 10.3 gdb, but somehow I can't attach a text file here it seems. I would suggest contacting Esri Tech Support so that they can take a closer look at this. ... View more

After copying the SDE connection file to the project location that was defined when creating the ArcGIS project --> Open the Project in ArcGIS Pro --> in the Project Pane, expand  Folders> Project Name --> You will see the connection files listed here --> Right Click on the connection file you need --> click on 'Add to Project' --> This will list the connection under Databases and you don't have to recreate them. This is helpful because, you can dump all SDE Connection files on a shared folder(if needed) --> Each person can connect to this folder using the "Add Folder Connection" option --> Choose the connection they need and add to their project. ... View more

Is that a simple Database or an Enterprise geodatabase? If it is a geodatabase, do you observe the same behaviour when connected as the SYSADMIN login? Rather have you tested with multiple logins and faced the same behaviour?  ... View more

Give it a try...in case you face any issues, that can be discussed as and when they come up... ... View more

Usually the CONNECT permission is all you need to connect to a Database. Too see data you need 'db_Datareader'. So, check whether the User-Mapping for that user was correctly done for that database. If it is a newly created Database login, maybe delete it and recreate the login and then check again. Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop  ... View more

One of the best explanations in brief I came across was in this link: Versioning 101  PDF: http://www.esri.com/news/arcuser/0110/files/versioning101.pdf  I'll suggest going through all the ArcGIS Help resource for a sound understanding of the Topic: An overview of versioning—ArcGIS Help | ArcGIS for Desktop  ... View more

On further looking into this, it seems that you may be able to use Oracle XE. Check this old link: FAQ: Can ArcGIS Server 9.3 Enterprise (all editions) be used with Oracle Express Edition (XE)?  I guess you saw it in an old GeoNet post, as mentioned on your GIS SE post --arcsde - Create a geodatabase (and st_geometry) in Oracle Express 11g R2 for home use - Geographic Information Systems S…  So, I guess as long as you are fine with the limitations of Oracle XE, you should be able to use it. However, if you need a confirmation to that old link, I'll suggest discussing with Esri Tech Support, to get the updated info.. ... View more

No, you cannot use the Express edition (XE) of Oracle for creating an Enterprise Geodatabase. You can! However, not in Production and that will not be supported by Esri, in case of any issues faced... Oracle database requirements for ArcGIS 10.3.x—Help | ArcGIS Desktop  Supported database versions Standard/Standard One/Enterprise Editions: Oracle 10g R2 (64-bit) 10.2.0.3 Oracle 11g R2 (64-bit) 11.2.0.3 Oracle 12c R1 (64-bit) 12.1.0.1 ... View more

rpm files are for Linux. So use the link that George provided to download the files for Windows OS. ... View more

True, surely there were some other reasons discussed, which I can't recall right now. Looking at the 10.5 link of  Database clients—Help | ArcGIS Desktop seems most of the Clients now have to be downloaded from the vendor sites directly. ... View more

No, Esri stopped providing Oracle Client setups on the My Esri site. If I remember correctly, it was because it is free and can be downloaded directly from the Oracle site. Database clients—Help | ArcGIS for Desktop  ... View more

Disclaimer: Have not worked with SAP Hana. It is somewhat apparent from the all the links I read that  Geodatabase functionality is not supported with SAP HANA SAP HANA database requirements for ArcGIS Pro 1.4—Help | ArcGIS Desktop  SAP HANA database requirements for ArcGIS 10.5—Help | ArcGIS Desktop  If the Geodatabase functionalities would have been available, those links should reflect that. From this link: Supported databases—Insights web help Use tab | ArcGIS Enterprise  it becomes clear that even Insight doesn't support Enterprise geodatabase Currently, Insights for ArcGIS does not allow you to create a connection to a relational database that has an enterprise geodatabase defined. Similarly, Insights does not work directly with file and personal geodatabases. For geodatabase tables and feature classes to be used in Insights, they must be made available in your portal organization as either hosted or registered feature layers, and then added to your workbook page. But as Rebecca stated, if you need an official confirmation, you should contact Esri Tech Support to get the latest updates. ... View more

You cannot modify the System Tables manually, it is not supported and may corrupt the Database. Are you using the "Change Privilege" tool? Are you connected as the owner of the data? Can you provide us with more information of the steps followed and the data that you are trying to grant privileges on... ... View more

Duplicate Thread of: https://community.esri.com/thread/188777-ora-00942-strange-issue  ... View more

Duplicate thread: https://community.esri.com/thread/188743-urgent-multiversioned-oracle-geodatabase  ... View more