An administrator creates "customer_table_admin" and "customer_table_user" roles for the newly created "Customer Table". Which ACL rule would grant access to all rows and all fields to both the custome

The correct answer is B. customer .*. The customer . ACL rule would grant access to all rows and all fields to both the customer_table_admin and customer_table_user roles because it uses a wildcard () to match any operation on the customer table. The other options are either too restrictive or too broad.

Submitted by andreas_gr· Apr 18, 2026Database Management and Platform Security

Question

An administrator creates "customer_table_admin" and "customer_table_user" roles for the newly created "Customer Table". Which ACL rule would grant access to all rows and all fields to both the customer_table_admin and customer_table_user roles?

Options

Acustomer.all
Bcustomer .*
Ccustomer.field
Dcustomer.none

How the community answered

(42 responses)

B
93% (39)
C
5% (2)
D
2% (1)

Explanation

The customer .* ACL rule would grant access to all rows and all fields to both the customer_table_admin and customer_table_user roles because it uses a wildcard (*) to match any operation on the customer table. The other options are either too restrictive or too broad.

Topics

#ACLs#Roles#Security#Custom Tables

Community Discussion

No community discussion yet for this question.

Full CSA Practice