DB Properties

The following are properties used when the source of the rules is db or coming from the database.

Property	Type	Required	Default	Description
rulesDSN	string	true if rulesSource = db	---	The dsn to use if the rules are coming from a database
rulesTable	string	true if rulesSource = db	---	The table where the rules are
rulesSQL	string	false	select* from rulesTable	The custom SQL statement to use to retrieve the rules according to the rulesTable property. If not set, the default of select* from rulesTable will be used.
rulesOrderBy	string	false	---	The column to order the rules by. If not chosen, the interceptor will not order the query, just select it.

interceptors = [
    {class="cbsecurity.interceptors.Security", name="ApplicationSecurity", properties={
        useRegex = true, rulesSource = "db", validatorModel = "SecurityService",
        rulesDSN = "myApp", rulesTable = "securityRules", rulesOrderBy = "order asc"
    }}
];