FAQ: Why are the Privileges and Analyze context menu items disabled for database datasets when connected as the owner of the dataset?
【相关信息】
Article ID: 40121
Software:
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2, 10.3
Platforms: N/A
【问题描述】
Why are the Privileges and Analyze context menu items disabled for database datasets when connected as the owner of the dataset?
Article ID: 40121
Software:
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2, 10.3
Platforms: N/A
【问题描述】
Why are the Privileges and Analyze context menu items disabled for database datasets when connected as the owner of the dataset?
1 个回复
易智瑞技术支持
赞同来自:
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.
【创建及修改时间】
Created: 4/9/2012
Last Modified: 11/5/2014
【原文链接】
http://support.esri.com/en/kno ... 40121
要回复问题请先登录或注册