DB Rules

If you have your security rules in a database, then cbsecurity can read the rules from the database for you. Just make the rules key equal to db and fill out the extra configuration keys shown below:

‚Äč

Property

Type

Required

Default

Description

rulesDSN

string

true

---

The dsn to use if the rules are coming from a database

rulesTable

string

true

---

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.

config/Coldbox.cfc
moduleSettings = {
// CB Security
cbSecurity : {
rules : "db", // Rules are in the database
rulesDSN : "myDatasource", // The datasource
rulesTable : "securityRules", // The table that has the rules
rulesOrderBy : "order asc" // An optional ordering
}
};