Database security

Is there a way to create and encrypted database file?

What do people do when data security is important at the file level? In
other words, you don't want anyone to be able to take the database file (or
files) and extract data from them.

Ideally, I want a file the is absolutely encrypted on disk and that is
decrypted for data access. The problem, obviously, is that this would be a
very costly (cpu time) approach as you couldn't create a decrypted image on
disk (this would expose the data).

Are all database systems then, non-secure?

Thanks,

-Martin

You could use Sql Server 2005, that should give you most of the options you
need.


MC

"Martin" <0_0_0_0_@pacbell.net> wrote in message
news:QH0mf.28501$7h7.12582@newssvr21.news.prodigy. com...
> Is there a way to create and encrypted database file?
>
> What do people do when data security is important at the file level? In
> other words, you don't want anyone to be able to take the database file
> (or files) and extract data from them.
>
> Ideally, I want a file the is absolutely encrypted on disk and that is
> decrypted for data access. The problem, obviously, is that this would be
> a very costly (cpu time) approach as you couldn't create a decrypted image
> on disk (this would expose the data).
>
> Are all database systems then, non-secure?
>
> Thanks,
>
> -Martin
>
>