Re: How to encrypt database schema(.mdf) of file

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 10/28/05

  • Next message: Sue Hoegemeier: "Re: SQLMail and restricted service account"
    Date: Fri, 28 Oct 2005 10:14:37 -0400
    
    

    You can't stop them from seeing it if they have sa rights. The only way to
    protect yourself legally is with proper copywrites and such.

    -- 
    Andrew J. Kelly  SQL MVP
    "Gautham" <bv_gautham@yahoo.com> wrote in message 
    news:43132353-FC67-4DCB-A9F5-B84E377CF1CE@microsoft.com...
    > Hi,
    >
    > I have developed an application in which SQL Server 2005 is used as 
    > backend.
    > Once i deploy the application on client machine, others will be able to
    > access the database schema. How to protect my database file (database 
    > schema)
    > from others viewing it ?
    >
    > Thanks in advance,
    > Gautham. 
    

  • Next message: Sue Hoegemeier: "Re: SQLMail and restricted service account"

    Relevant Pages

    • Re: database password and encryption
      ... I know the basic concepts about encryption. ... This database should be encrypted with a strong, ... way you can protect the database AT ALL. ... I could encrypt the key several times and hide the new, resulting, keys on ...
      (microsoft.public.platformsdk.security)
    • Re: password-copyright
      ... it's basically the same exact mechanism as a login ... verify one item, such as a keyword, phrase, or password. ... database and if it is, you set a cookie saying they are authenticated. ... trying to protect your work or some similar profession, ...
      (microsoft.public.frontpage.client)
    • Re: MDF file level security from copying
      ... is a way to protect the MDF files, ... located on FAT like Windows 98 and Windows ME, ... >BTW, if you are concerned about the database schema, as ... >> file while the sql server is stopped? ...
      (microsoft.public.sqlserver.security)
    • Re: Help! Back button - Redesign Project???
      ... The best way to protect the database is to build protection into the ... A unique index can protect you from users inserting duplicate records ... use a concurrency ID on the table that increments for each ... In your update procedure, check for the value of the ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Help! Back button - Redesign Project???
      ... > A unique index can protect you from users inserting duplicate records ... > in subsequent posts. ... > The best way to protect the database is to build protection into the ...
      (microsoft.public.dotnet.framework.aspnet)