SQL 2005 express security issue

Hi,

We just revamp our application from Access to use SQL Express 2005 as database engine, which is a standalone application running on client PC.

I'm now simulating the scenario when I deploy the DB to client, how can I protect the database (or some tables) from being read by them?

Since this application will distribute to client PC, which is out of our control, so we must choose SQL authentication.

What I got is, when I setup a SQL express in a new machine, and attach the database I want to protect, login as 'sa', I can read everything inside, no matter what & how I set.

Is it true that I can't protect database/table in SQL authentication mode?

Please help.

.

Relevant Pages

  • Re: Dont understand what version of SQL to install
    ... I created a database using sql 2005 express edition. ... With that in mind - could you use SQL Server 2008 Developer Edition? ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Dont understand what version of SQL to install
    ... but "moving" a database implies a degree of automation. ... Principal SQL Infrastructure Consultant ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Database Server based on SQL database
    ... the raw database over WAN. ... So I will write a server program which receives requests from clients via ... Should I base this protocol on SQL or design my own protocol. ... ie the client doesn't have OLE DB, ADO, DAO or whatever installed - ...
    (microsoft.public.win32.programmer.networks)
  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server). ... > 20 tables in different relations with eachother in the database, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... but as a client, there are many applications that can act as client as already pointed out. ... Access front end to a SQL database, Excel can be a front end, A word mail merge document could access a SQL database via ODBC. ... We are trying to install the client software. ...
    (microsoft.public.backoffice.smallbiz2000)