Database ACL

[292000]

Hi! I noticed that even if you enforce ACL in a certain Database, this DB can still be accessed by those who should not have any access of it...how can I enforce an effective ACL so that only those people who should be able to access it can really access it.
Thanks!

 

[Guy987]

On the advanced tab of the properties of the database, click the "Enforce a consistent ACL across all replica's" setting, otherwise if they pull a local copy of it, they will be a manager of the local copy.

Be certain that you give yourself or an admin group access to the database. You will also need to give the group local domain servers access to the database as well, otherwise server agents and replica's across the servers will not work...

Hope this helps.

Leo L'Homme, PCLP