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?
已邀请:

EsriSupport

赞同来自:

解决方案
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

要回复问题请先登录注册