Re: HELP: Read-Only Snapshots (Security)

Only in terms of looking at the data. If the user that created the snapshot can only read the information, then so can the intruder. However, they will have access to the information via the snapshot anyway. The only way that the intruder can actually access the tables is to know SQL construct, including database links. The truth is, you can't lock a system down completely, your security is only as reliable as your users.

-Sheilah Scheurich
DBA Leonid Lamburt wrote:

> Please help:
>
> I am trying to sync two databases by creating Read-Only snapshots in the
> target database.
> As I understand, I also have to create a dblink in the target database for
> automatic snapshot refresh. Because of lack of experience, I cannot assess
> the security conseqences of
> this approach.
> Lets say, the security of the target database is compromized (the intruder
> has access
> to the objects of the user that created the snapshots).
> Does it mean that the security of the source database is also compromized?
> (If yes, than in what way?)
>
> Thanks in advance.
>
> Leonid
Received on Wed Jan 14 1998 - 00:00:00 CST