Skip to Main Content

Cloud Security, Observability and Administration

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!

How do I specify a literal "*" when creating a rule for an OCI event

Nizar_BSCDec 19 2024

When creating a Rule for an Event in OCI (eg Application Integration -> Events Service -> Rules), or from the CLI as per https://docs.oracle.com/en-us/iaas/tools/oci-cli/3.51.0/oci_cli_docs/cmdref/events/rule/create.html, wildcard matching is supported with the asterisk (*) character. But how do I escape (*), so that the condition is looking for a literal "*" and not treating it as a wildcard.

eg, the following rule logic

MATCH event WHERE (eventType EQUALS ANY OF (com.oraclecloud.datasafe.generateauditalert)AND (commandText MATCHES ANY OF (*PHONE_TYPE*,*PHONE_NUMBER*)))

would evaluate to true for any any SELECT statement with PHONE_TYPE or PHONE_NUMBER in the SQL text, but I want the condition to also evaluate to true if there is an "*" in the SQL text, ie "SELECT * from…"

Comments
Post Details
Added on Dec 19 2024
0 comments
274 views