Frequently asked question
Why are the Privileges and Analyze context menu items disabled for database datasets when connected as the owner of the dataset?
Answer
ArcGIS relies on the connecting user and its schema name to be the same. Microsoft SQL Server and PostgreSQL do not have this requirement. If a connection is made from ArcGIS for Desktop to an existing table in a SQL Server or PostgreSQL database as a user who has privileges on the schema the table is in, the data can be viewed but cannot be managed from ArcGIS for Desktop.For example, if all the tables in a PostgreSQL database are stored in the public schema, the data can be viewed in ArcMap, but tables cannot be analyzed and privileges cannot be granted on them from ArcMap. Additionally, tables cannot be truncated, data cannot be loaded to them, and columns cannot be added to, removed from, or renamed in the tables from ArcMap.
Article ID:000011541
Software:
- ArcMap
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App