All geek questions in one place

How to protect the password of my SQL Server database?

I want to deploy my SQL Server 2008 database with an application on a client machine, where I do not want anyone to be able to open and read or copy my database objects (i.e. tables, SP, functions, views, etc. .). I want to protect the database with the same password as Microsoft Access 2007. When someone opens, he asks for a password. This can be done in SQL Server 2008, if so, how.

+3
source share
2 answers

SQL Server is not like Access, and does not have file-based password protection mechanisms (in "regular" versions such as Web, Standard, Enterprise / Developer, Express).

SQL Server - - , , SQL Server (, ).

- Access, SQL Server Compact Edition,

+2

, , , - SQL Server. , - "" SQL Server, , .

+2

Source: https://habr.com/ru/post/1793344/

More articles:


All Articles