Forum Discussion

Hawo67's avatar
Hawo67
Copper Contributor
Apr 11, 2024

Disabe Security

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?

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Apr 12, 2024

     

    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.

Resources