11g: ORA-55620: No privilege to use Flashback Archive, however the user granted FLASHBACK ARCHIVE object privilege.
Last updated on OCTOBER 12, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 220.127.116.11 to 18.104.22.168 - Release: 11.1 to 11.1
Information in this document applies to any platform.
SQL> grant flashback archive on fla1 to scott;
The flashback archive user can enable flashback archive on the table (EMP), however got error ORA-55620: No privilege to use Flashback Archive when trying to disable flashback archive on the table.
As user SCOTT:
SQL> alter table emp flashback archive fla1;
SQL> alter table emp no flashback archive;
alter table emp no flashback archive
ERROR at line 1:
ORA-55620: No privilege to use Flashback Archive. <<<
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms