Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What would I need to do to UNDO or reverse a bad GRANT ALL PRIVILEGES statement? ROLLBACK, FLASHBACK

RedWhiteNBlueApr 2 2020 — edited Apr 5 2020

I'm playing with my Oracle Database to learn how things work. Specifically, I want to see what happens when I grant and revoke privileges. But I don't want to mess up the database to a degree of having to restore it from scratch.

So, from what I understand all GRANT statements are DDL statements. So, the ROLLBACK clause is probably stricken from the list immediately.

What option or clause is the easiest to use to ensure I can immediately UNDO a faulty GRANT statement without a heavy performance hit. I want to use a surgical knife here and not a sledgehammer.

Along the same lines of thought, since I brought it up, in the worst case scenario, how would I get a virgin copy of my XEPDB1 that came with my installation of Oracle's XE. Is it just a matter of having a duplicate copy of the XEPDB1 file? I didn't think to make a copy from the beginning though.

Comments
Post Details
Added on Apr 2 2020
21 comments
2,791 views