May 7, 2012 at 5:45 pm
I have a snapshot of a mirrored database, and a database that holds the links to the snapshot, which updates every 10 minutes. I want to pull the database roles info from the snapshot to maintain the same security on the Report database. How can I get this out of the snapshot?
I think the easiest way is to get it from the original database, but I'm looking for a generic solution that could be used in other similar scenarios...
May 7, 2012 at 9:06 pm
Why you only want database roles information from snapshot database. If the snapshot is queried for data on any page that has not been modified in the source database, since the time the snapshot was created, then the request is simply redirected to the source database files.
May 8, 2012 at 9:33 am
Because permissions are role based. All users are members of a role, so the role should have the same permissions in the RPT database, no?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply