SQL Database Security
-
HI ALL, Is it possible to secure sql database using user name password, not the mixed mode user name password, (user name password ) on database it self to prevent it when restore on other sql engine(instance). the second questions is how to hide columns on sql server database engines, when open the database can't see the tables and columns until i enter the database user name password Thanks all
-
HI ALL, Is it possible to secure sql database using user name password, not the mixed mode user name password, (user name password ) on database it self to prevent it when restore on other sql engine(instance). the second questions is how to hide columns on sql server database engines, when open the database can't see the tables and columns until i enter the database user name password Thanks all
zead wrote:
Is it possible to secure sql database using user name password, not the mixed mode user name password, (user name password ) on database it self to prevent it when restore on other sql engine(instance).
Yes; put them in a password-protected zipfile. There's no password required for a backup or the database-file.
zead wrote:
the second questions is how to hide columns on sql server database engines, when open the database can't see the tables and columns until i enter the database user name password
Limit the users' rights. There's no way to keep the DBA of the server "out".
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
HI ALL, Is it possible to secure sql database using user name password, not the mixed mode user name password, (user name password ) on database it self to prevent it when restore on other sql engine(instance). the second questions is how to hide columns on sql server database engines, when open the database can't see the tables and columns until i enter the database user name password Thanks all
You can encrypt the database and that mat protect your data across a restore, I have never had to do this so I do not have a definitive answer! Hiding columns in a table view is not possible (I think) but you can create views exposing the columns you want to display for each group of users. Then only give permission for the user to the views and not any other objects.
Never underestimate the power of human stupidity RAH