New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open

nj1973 opened this issue Mar 22, 2024 · 0 comments

Labels

Collaborator

nj1973 commented Mar 22, 2024

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?

nj1973 added the documentation label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment