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.
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)