Change Accessor database structure
Status: Beta
Brought to you by:
jsulliva
Accessors should use an unique AccID like Resources use ResID. This means removing the keystring1, keystring2, and tablename columns from access_groups and adding accid. The Primary key should become chainname + accid. The accessors_ip and accessors_x509 tables should be merged with the primary key being accid. They will have fields from each and a new type column to indicate the type of Accessor. We could have columns like accrange, cn, and dn for each with unnecessary columns left empty or we could use the keystring1, keystring2 convention to reduce the number of columns.
Anonymous
No, we need a separate table per Accessor type keyed to the accessors database table by accid. accessors database has only accid, type, and comment