Hi. I am using Oracle db 19c Enterprise edition.
When SYS user executes the following …
REVOKE EXECUTE ON DBMS_BACKUP_RESTORE FROM PUBLIC;
I got error…
"cannot REVOKE privileges you did not grant"
I thought SYS could revoke any privilege from any user but that does not seem to be the case.
What could be the reason for that?