topic User permissions on SDE stored procedure SQL Server in Data Management Questions https://community.esri.com/t5/data-management-questions/user-permissions-on-sde-stored-procedure-sql/m-p/442799#M25241 <HTML><HEAD></HEAD><BODY><SPAN>Hi guys,</SPAN><BR /><SPAN>I do not like the fact that public role has 'execute' permission on sde system stored procedures because it potentially allows (correct me if I'm wrong) to mess around sde system tables for a user that has only select permissions on all tables (sde and gdb included).</SPAN><BR /><BR /><SPAN>Are all permissions really necessary or the default configuration is a bit generous (for example default permissions on GDB tables are redundant for a geodatabase reader) ? Is there a minimum subset of stored procedures which is really necessary for a database reader ? </SPAN><BR /><BR /><BR /><BR /><SPAN>Any workaround ?</SPAN><BR /><BR /><BR /><SPAN>Alberto</SPAN></BODY></HTML> Thu, 28 Jul 2011 15:05:42 GMT AlbertoAloe 2011-07-28T15:05:42Z User permissions on SDE stored procedure SQL Server https://community.esri.com/t5/data-management-questions/user-permissions-on-sde-stored-procedure-sql/m-p/442799#M25241 <HTML><HEAD></HEAD><BODY><SPAN>Hi guys,</SPAN><BR /><SPAN>I do not like the fact that public role has 'execute' permission on sde system stored procedures because it potentially allows (correct me if I'm wrong) to mess around sde system tables for a user that has only select permissions on all tables (sde and gdb included).</SPAN><BR /><BR /><SPAN>Are all permissions really necessary or the default configuration is a bit generous (for example default permissions on GDB tables are redundant for a geodatabase reader) ? Is there a minimum subset of stored procedures which is really necessary for a database reader ? </SPAN><BR /><BR /><BR /><BR /><SPAN>Any workaround ?</SPAN><BR /><BR /><BR /><SPAN>Alberto</SPAN></BODY></HTML> Thu, 28 Jul 2011 15:05:42 GMT https://community.esri.com/t5/data-management-questions/user-permissions-on-sde-stored-procedure-sql/m-p/442799#M25241 AlbertoAloe 2011-07-28T15:05:42Z