SQL Server Security

By sehulsoni ·
hey I want to secure my database's mdf file, which can not be open from Enterprise.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Enterprise a is tool that connects to

by Tony Hopkinson In reply to SQL Server Security

a database, it doesn't 'open an MDF file'

Anyone who can reach the database server, with a valid user name and password, that maps to a database user, can use enterprise to do exactly what that user can do

That is the security mechanism.

What they can do as that user, which passwords they know, is implementing the security. Nothing to do with whether they are using Enterprise, external links from Excel or a VB app you wrote yesterday.

You are looking at it from the wrong end, you don't use applications to secure your data, you use the database to do it, via tools such as enterprise.

Related Discussions

Related Forums