ArcSDE 9.3.1
PostgreSQL 8.3 (installed via SDE media)
sde schema
PostgreSQL role called "gis" owns all data.
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.
GRANT USAGE ON SCHEMA sde TO windows-account;
GRANT USAGE ON SCHEMA gis TO windows-account;
Grant read only permissions to a featureclass using ArcCatalog.
When this windows-account connects to the database, the user sees the featureclass, but also a SDE table with the same name. What is that about?
