AnsweredAssumed Answered

Grant Read Access to SDE_Compress_Log

Question asked by bcollins@mt.gov on Jun 20, 2019
Latest reply on Jun 20, 2019 by cswadner

How can I grant read-only (select) access to non database owner users for the SDE_Compress_Log table in SQL Server 2016 or ArcGIS Desktop 10.6.1? I've tried in both environments and the settings seem correct. That table belongs to the SDE schema, while other users belong to a different schema. Users that are in the db_owner role can see it, but those in db_datareader and/or db_datawriter roles cannot see this table.

Outcomes