topic PostgreSQL 8.3 windows authentication in Data Management Questions https://community.esri.com/t5/data-management-questions/postgresql-8-3-windows-authentication/m-p/612898#M34563 <HTML><HEAD></HEAD><BODY><SPAN>ArcSDE 9.3.1</SPAN><BR /><SPAN>PostgreSQL 8.3 (installed via SDE media)</SPAN><BR /><SPAN>sde schema</SPAN><BR /><SPAN>PostgreSQL role called "gis" owns all data.</SPAN><BR /><BR /><SPAN>I read where if you want to use a windows account to authorize to PostgreSQL SDE, you need to modify the pg_hba.conf to include sspi as the auth-method for that line entry.</SPAN><BR /><BR /><SPAN>GRANT USAGE ON SCHEMA sde TO windows-account;</SPAN><BR /><SPAN>GRANT USAGE ON SCHEMA gis TO windows-account;</SPAN><BR /><BR /><SPAN>Grant read only permissions to a featureclass using ArcCatalog.</SPAN><BR /><BR /><SPAN>When this windows-account connects to the database, the user sees the featureclass, but also a SDE table with the same name.&nbsp; What is that about?</SPAN></BODY></HTML> Thu, 26 Jan 2012 16:15:06 GMT LeoDonahue 2012-01-26T16:15:06Z PostgreSQL 8.3 windows authentication https://community.esri.com/t5/data-management-questions/postgresql-8-3-windows-authentication/m-p/612898#M34563 <HTML><HEAD></HEAD><BODY><SPAN>ArcSDE 9.3.1</SPAN><BR /><SPAN>PostgreSQL 8.3 (installed via SDE media)</SPAN><BR /><SPAN>sde schema</SPAN><BR /><SPAN>PostgreSQL role called "gis" owns all data.</SPAN><BR /><BR /><SPAN>I read where if you want to use a windows account to authorize to PostgreSQL SDE, you need to modify the pg_hba.conf to include sspi as the auth-method for that line entry.</SPAN><BR /><BR /><SPAN>GRANT USAGE ON SCHEMA sde TO windows-account;</SPAN><BR /><SPAN>GRANT USAGE ON SCHEMA gis TO windows-account;</SPAN><BR /><BR /><SPAN>Grant read only permissions to a featureclass using ArcCatalog.</SPAN><BR /><BR /><SPAN>When this windows-account connects to the database, the user sees the featureclass, but also a SDE table with the same name.&nbsp; What is that about?</SPAN></BODY></HTML> Thu, 26 Jan 2012 16:15:06 GMT https://community.esri.com/t5/data-management-questions/postgresql-8-3-windows-authentication/m-p/612898#M34563 LeoDonahue 2012-01-26T16:15:06Z