Username/password protected database
-
I need to secure only one particular database in SQL Server so I could access it only with certain predefined username/password. So, I am login in SQL Server as windows authenticated or sa and see all databases with details, but, for one database I want to see her in list but cannot access further without user/pass.
-
I need to secure only one particular database in SQL Server so I could access it only with certain predefined username/password. So, I am login in SQL Server as windows authenticated or sa and see all databases with details, but, for one database I want to see her in list but cannot access further without user/pass.
sa owns the server so you cannot exclude sa from the database. You then need to delete all other credentials from the database.
Never underestimate the power of human stupidity RAH
-
I need to secure only one particular database in SQL Server so I could access it only with certain predefined username/password. So, I am login in SQL Server as windows authenticated or sa and see all databases with details, but, for one database I want to see her in list but cannot access further without user/pass.
I'm experiencing the same problem and I need help.
-
I'm experiencing the same problem and I need help.
You can't "lock" the database with a password. The only way to "protect" your database-model is to keep it on your own server and to provide a web-service to access it. The owner of the server will be considered the owner of the data, and you can't lock the owner out.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]