|
| Hi All,
I've been looking into the bottomless depths of replication, and one thing
I've come across are the schema bound views that it creates (the ones that
are prefixed with syncobj_)... ...I believe the views are created for the
snapshot replication that occurs across all three replication types, the
thing is I've noticed by default SQL puts select permissions on these views
in the public role.
We have some sensitive data that isn't something we want everyone with
access to the database to be able to potentially view. If I understand the
process correctly, I figure we can't drop the views in case we ever need to
pass across another snapshot... ...however I would like to amend the
permissions, I've traced replication on my test box, and I've noticed that
it's only the SQL Agent login that accesses these views, so as our agent
logins are sa's, I want to go ahead and remove the default permissions from
public. Can anyone see any issues with this?
As always any feedback is greatly appreciated
Thanks
Ben
|
|