Re: Password MDF

That has nothing to do with encrypting the columns. Look up Encryption for SQL Server 2005 in BooksOnLine for details of how this works.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Julián Sanz García" <jsanz@xxxxxxxxxxxx> wrote in message news:u2bFRXtFIHA.3768@xxxxxxxxxxxxxxxxxxxxxxx
Hi Andrew,

Thank you very much for your answer. I have found information about this issue and it says the same. Otherwise, can i make a connectionstring with user and password to restrict the access from code or do i have to use always "Integrated Security=True"?

Best regards

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> escribió en el mensaje news:ur1tzDnFIHA.5272@xxxxxxxxxxxxxxxxxxxxxxx
If the end user has sa rights on that server they can see what ever they wish by default. You might want to think about encrypting those columns and using a key that your app supplies to decode them.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Julián Sanz García" <jsanz@xxxxxxxxxxxx> wrote in message news:upUufJlFIHA.3672@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

¿Are there any way to protect a database that is reditributed with a desktop application? I want to protect this database with an user and a password, something like access, but with SQL Server 2005, if you have SQL Server 2005 Management Studio, you can access without any problems and you can see all database objects.

Thanks a lot





.

Relevant Pages

  • Re: Determine Disk Block Size ?
    ... As always, thanks Andrew. ... Most of the documentation for 2000 is wrong in that it may state you need multiple files to spawn multiple threads. ... >> The MS SQL Server Operations Manual makes a recommendation of using 64-KB>> cluster sizes. ... We have done so with a dramatic total disk I/O>> throughput. ...
    (microsoft.public.sqlserver.server)
  • Re: How to convert the SQL Developer Edition to SQL Standard Editi
    ... drivers point since the server will be the same as long as you upgrade the ... Andrew J. Kelly SQL MVP ... >>> under Database properties->Data Files, ... >>>> you can not avoid rerunning setup for SQL Server to get to Std ...
    (microsoft.public.sqlserver.setup)
  • Re: Locking
    ... Andrew, Pessimistic is the default. ... > transaction isolation mode and set as with IMPLICIT TRANSACTIONS. ... > SQL Server when you connect. ... >> We are using Borland delphi and bde to communicate with the database. ...
    (microsoft.public.sqlserver.server)
  • Migration Question Again...
    ... Sorry to ask a stupid question again since this is the first time that i do migration. ... I've got response from Andrew. ... for SQL Server ... I am not sure if I should use Copy Database Method to move all the objects or use sp_attached/sp_detached. ...
    (microsoft.public.sqlserver.setup)
  • Re: different environment fails to fill a dataset
    ... Well I recreated the login but it didn't make any difference. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)