Select to view content in your preferred language

Can the SQL Server schema be specified when creating a new feature class?

5772
10
Jump to solution
05-18-2021 03:15 PM
Labels (1)
AndrewGilbert
Occasional Contributor

I'm connecting to a SQL Server database using "Operating system authentication" (in this case Active Directory pass-through). To keep data organized, I would like to create feature classes in different schemas within that database. I can create the schemas ahead of time in SSMS (SQL Server Management Studio).

However, when I go to create a feature class through ArcGIS Pro or ArcMap, I don't see an option to select a schema. Can the schema be specified when creating a new feature class?

Operating system authentication is a hard requirement, but I'm open to workarounds that involve schema owners.

10 Replies
DavidHoy
Esri Contributor

Hi,
By default, only the data owner can "see" the items in their schema - and that is reflected in the Catalog pane of ArcGIS Pro.
but, this could happen if your users (or a role/group of which they are a member) had been granted access by the schema owner, or  have been granted db_datareader or db_datawriter system role.