DBA > Job Interview Questions > Microsoft SQL Server FAQs

You are looking to secure your publisher to prev

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?

Answer
Add them to the Publication Access List in the publication database.

Explanation
All access to publications is controlled with the Publication Access List (PAL), which is similar to the Windows ACLs. A list is created for each publication that is set up.

(Continued on next question...)

Other Job Interview Questions