topic Does ArcMap support user mappings when connectionto PostgreSQL database? in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/does-arcmap-support-user-mappings-when/m-p/644390#M24711 <HTML><HEAD></HEAD><BODY><P>I've set up a PostgreSQL server to house production geodatabases, where 50+ analysts will edit data on various databases.&nbsp; I've set up a 'sde' login, a 'data_owner' login, and an 'editor' group.&nbsp; It is desirable to track user edits on some of our databases.&nbsp; I would like to use our acitve directory credentials to allow users to login without requiring a separate login.&nbsp; Unfortunately, our domain uses a format <STRONG>firstname.lastname</STRONG> for users, and this is not wrapped in double quotes when ArcMap communicates with the pg server.&nbsp; So when a <STRONG>john.doe</STRONG> tries to select more than 100 features, or any other act that will need to make use of the log file tables, an error occurs.&nbsp; Using our current active directory names will not work.</P><P></P><P>After reading some PG documentation, I realized I might be able to map our illegal OS user names to legal PG user names.&nbsp; (e.g. <STRONG>john.doe</STRONG> authenticates as <STRONG>john_doe</STRONG>).&nbsp; After initial tests, I have been unable to get this to work either.&nbsp; I don't know if this is due to, again, unseen communications between ArcMap and PG.&nbsp; Is something like this even possible in the ESRI ecosystem, or am I just trying to fit a round peg in a square hole?&nbsp; Short of creating a pg user for every os user, what, if any, options do I have for using our active directory?</P></BODY></HTML> Wed, 09 Jan 2019 17:08:27 GMT WWalker 2019-01-09T17:08:27Z Does ArcMap support user mappings when connectionto PostgreSQL database? https://community.esri.com/t5/arcgis-enterprise-questions/does-arcmap-support-user-mappings-when/m-p/644390#M24711 <HTML><HEAD></HEAD><BODY><P>I've set up a PostgreSQL server to house production geodatabases, where 50+ analysts will edit data on various databases.&nbsp; I've set up a 'sde' login, a 'data_owner' login, and an 'editor' group.&nbsp; It is desirable to track user edits on some of our databases.&nbsp; I would like to use our acitve directory credentials to allow users to login without requiring a separate login.&nbsp; Unfortunately, our domain uses a format <STRONG>firstname.lastname</STRONG> for users, and this is not wrapped in double quotes when ArcMap communicates with the pg server.&nbsp; So when a <STRONG>john.doe</STRONG> tries to select more than 100 features, or any other act that will need to make use of the log file tables, an error occurs.&nbsp; Using our current active directory names will not work.</P><P></P><P>After reading some PG documentation, I realized I might be able to map our illegal OS user names to legal PG user names.&nbsp; (e.g. <STRONG>john.doe</STRONG> authenticates as <STRONG>john_doe</STRONG>).&nbsp; After initial tests, I have been unable to get this to work either.&nbsp; I don't know if this is due to, again, unseen communications between ArcMap and PG.&nbsp; Is something like this even possible in the ESRI ecosystem, or am I just trying to fit a round peg in a square hole?&nbsp; Short of creating a pg user for every os user, what, if any, options do I have for using our active directory?</P></BODY></HTML> Wed, 09 Jan 2019 17:08:27 GMT https://community.esri.com/t5/arcgis-enterprise-questions/does-arcmap-support-user-mappings-when/m-p/644390#M24711 WWalker 2019-01-09T17:08:27Z