Looking at a geodatabase in Azure SQL database, the PUBLIC server role has permissions on many geodatabase objects, including INSERT and DELETE on some SDE_* tables, and EXECUTE on data modifying stored procedures.
What this means is that any user added to the database has these privileges by default. Is this necessary for the proper functioning of the geodatabase and, if not, which permissions can be removed from the PUBLIC user role?
Solved! Go to Solution.
The below link will partially answer your question:
So, in short, these are necessary but can also be revoked from PUBLIC role and granted to other users separately. Probably try it out on a test database and make sure everything is working first.
The below link will partially answer your question:
So, in short, these are necessary but can also be revoked from PUBLIC role and granted to other users separately. Probably try it out on a test database and make sure everything is working first.
Thank you, Asrujit. This is the best information that I've seen on this.