I am a Support Engineer and have had one of my clients ask me
Why would there be negative access rights in a stand-alone database?
I have a very limited understanding of SQL and my DBA is on extended leave so I am hoping I can get an answer from here. It is my understanding that negative access rights are created when the Deny command is used for a users access permission within SQL and that best practice is to use the revoke command to remove the negative permission entries but there has not been any DB administration performed so what else could cause this issue?
Many thanks in advance