Few days ago, wail a regular check I found that I have forgot to add permissions to my designers SQL group over the new AutoCAD PLANT3D project and databases and yet they are all working regularly.
After some digging I found that when AutoCAD creates a new project it automatically grants control permissions to the public SQL role.
As per my understanding this is a major security breach and I have revoked the control permission from the public role over all my databases.
Attached is the script I used to revoke the control permission from the public role over all my databases.
כתיבת תגובה