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.