gluent / goe

GOE: a simple and flexible way to copy data from an Oracle Database to Google BigQuery.
Apache License 2.0
8 stars 2 forks source link

Document need for and low risk of FLASHBACK ANY TABLE #134

Open nj1973 opened 6 months ago

nj1973 commented 6 months ago

This permission sounds scary but is actually no riskier than SELECT ANY TABLE when not combined with IUD privileges. As described here: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/FLASHBACK-TABLE.html#GUID-FA9AF2FD-2DAD-4387-9E62-14AFC26EA85C

We should document this somewhere because we've had to explain it a few times. Perhaps in the grant SQL next to the command is the best place?