topic Re: Grant Read Access to SDE_Compress_Log in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768437#M796 <HTML><HEAD></HEAD><BODY><P>Ok, another option would be to create a new table and copy/paste the data via python from the sde_compress table into something that they would be able to have permissions to.</P></BODY></HTML> Thu, 20 Jun 2019 17:20:35 GMT George_Thompson 2019-06-20T17:20:35Z Grant Read Access to SDE_Compress_Log https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768434#M793 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 20 Jun 2019 16:25:01 GMT https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768434#M793 BrianCollins 2019-06-20T16:25:01Z Re: Grant Read Access to SDE_Compress_Log https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768435#M794 <HTML><HEAD></HEAD><BODY><P>I am curious why you would want to share that with non-GDB admins?</P></BODY></HTML> Thu, 20 Jun 2019 16:36:13 GMT https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768435#M794 George_Thompson 2019-06-20T16:36:13Z Re: Grant Read Access to SDE_Compress_Log https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768436#M795 <HTML><HEAD></HEAD><BODY><P>This particular database is heavily versioned and runs automated nightly reconcile, post, indexing and compression processes. Some of our power users have requested read-only access to the resource so that they can confirm that processes executed and the database was compressed.</P></BODY></HTML> Thu, 20 Jun 2019 16:42:06 GMT https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768436#M795 BrianCollins 2019-06-20T16:42:06Z Re: Grant Read Access to SDE_Compress_Log https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768437#M796 <HTML><HEAD></HEAD><BODY><P>Ok, another option would be to create a new table and copy/paste the data via python from the sde_compress table into something that they would be able to have permissions to.</P></BODY></HTML> Thu, 20 Jun 2019 17:20:35 GMT https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768437#M796 George_Thompson 2019-06-20T17:20:35Z Re: Grant Read Access to SDE_Compress_Log https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768438#M797 <HTML><HEAD></HEAD><BODY><P>Or you could create an ssrs report and email them a report.</P><P></P><P>This is what we do…</P><P></P><P></P><P></P><P>Craig Swadner (GIS Coordinator)</P><P>City of Cape Coral</P><P>1015 Cultural Park Blvd.</P><P>Cape Coral, Fl 33990</P><P></P><P>Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net</P></BODY></HTML> Thu, 20 Jun 2019 17:57:36 GMT https://community.esri.com/t5/geodatabase-questions/grant-read-access-to-sde-compress-log/m-p/768438#M797 CraigSwadner 2019-06-20T17:57:36Z