Is BCM database somehow protected or encrypted against local copy?

[sunorain]

Assuming somebody got access to PC where BCM installed and copied SQL files
related to BCM database - will it mean that data containing there will be
disclosed.

If such - is it possible to protect or encrypt BCM database so that noone
could access it even locally without password?

 

[Luther]

Assuming somebody got access to PC where BCM installed and copied SQL files
related to BCM database - will it mean that data containing there will be
disclosed.

If such - is it possible to protect or encrypt BCM database so that noone
could access it even locally without password?

It may be possible to encrypt the data using just Sql Server settings.
Note that encryption will have an effect on performance.

That said, the database file is stored in the database creator's part
of the disk, so only the creator has access to the file. The
administrator login can also access the file, and the login the Sql
service is running under too, so I would say that you can have
reasonable security by controlling which users you grant administrator
privileges to.