Application Access Control

Question 1

3 levels of security before an end user can CRUD

Answer 1

User Auth/Login, App and modules access, database access

Question 2

3 security modules

Answer 2

All>System Properties>Security, All>System Security>ACL or High Security Settings

Question 3

access control may be set at the…

Answer 3

row-level and/or column-level

Question 4

what are automatically created when a table is created

Answer 4

create, delete, read, and write acls and an associated role

Question 5

3 things each acl specifies

Answer 5

operation, object, permissions

Question 6

what are the three permissions in an acl

Answer 6

roles, conditional expressions, scripts

Question 7

which acl rule type applies to the whole table including all of its records

Answer 7

table.-None-

Question 8

which acl rule type applies to only one field on a record

Answer 8

table.field

Question 9

which acl rule type applies to every field on a record without a table.field rule?

Answer 9

wildcard (table.*)

Question 10

record acl rules are processed in what order

Answer 10

match the object against table ACL rules, most specific to most general, then field ACL rules, most specific to most general

Question 11

true or false: failing any one permission check prevents the user from accessing the matching object and operation

Answer 11

true