Disabe Security

Copper Contributor

Hi, we use SQL Server Express 2022 for development. I have created a simple Database with one table. I want to disable User Security global.

Ist this possible and how?

1 Reply

 


I want to disable User Security global.

@Hawo67 , I am not sure, if I got you right; everyone should be able to access the database?

You can enable the "guest" account and grant permission for, then everyone can access using Windows Authentication. See

Guest Permissions on User Databases - SQL Server | Microsoft Learn

But for security view it's more then a high risk, because really everyone can access including virus/malware.