I installed a new instance of SQL Server to restore the database that I have. I also set up user authorization by creating a user login and setting a password (SQL Server authentication mode). However, after restoring the database, there was no security in my database, the client looked at the location in the database file and was able to view my queries!

Is there any way to stop this database access?
thank
source
share