SQL Server creates a read-only account

Sometimes a read-only account is created to make it easier to check the data, so that the SQL statements are not changed by mistake.

Step: After connecting with SA account, security--Login name--NEW

Enter the account password you want to create, and tick the server role to a public

Tick the user map to select the database to operate, then tick db_datareader, db_denydatawrite, public

OK, yes.

After you've created it, find a useless table. Test the test UPDATE statement

SQL Server creates a read-only account