Information
The LOGSTDBY_ADMINISTRATOR role provides privileges to administer logical standby databases. Unauthorized grantees can perform operations that can disrupt logical standby database.
Unauthorized changes may impact logical standby database replication and lead to data inconsistency
Solution
To remediate this setting, execute the following SQL statement, keeping in mind if this is granted in both container and pluggable database, you must connect to both places to revoke. Please ensure proper impact analysis is done before revoking the privilege from a role.
REVOKE LOGSTDBY_ADMINISTRATOR FROM <grantee>;
In the case of a grant via a role:
REVOKE <rolename> FROM <grantee>;