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.
Solved! Go to Solution.
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.