The security rule table. This is where the user, the asset, and the access permission all come together
| Column Name | Column Datatype | Column Null Option | Column Comment |
| usernode | varchar(64) | not null | The node where the accessing user exists. |
| userid | varchar(32) | not null | The id of the accessing user, ie: bobjones001. |
| usertype | varchar(8) | not null | The type of user id. This can be USER or GROUP. In the latter case, the user id is actually the group id |
| assetid | varchar(255) | not null | The name of the asset to be protected, ie: * |
| assetnode | varchar(64) | not null | The node where the asset to be protected exists |
| assettype | varchar(24) | not null | The type of the asset to be protected, ie: ca-calendar |
| accesstype | varchar(8) | not null | The type of access, either PERMIT or DENY |
| expires | integer | with null | Expires int, (The expiration date for this rule) |
| calendar | varchar(20) | with null | A NSM calendar name, such that when specified and active, the rule is in effect |
| profile | varchar(255) | with null | Not currently used |
| accessread | char(1) | with null | Flag to specify securing of read access |
| accesswrite | char(1) | with null | Flag to specify securing of write access |
| accessdelete | char(1) | with null | Flag to specify securing of delete access |
| accessupdate | char(1) | with null | Flag to specify securing of update access |
| accessexecute | char(1) | with null | Flag to specify securing of execute access |
| accesssearch | char(1) | with null | Flag to specify securing of search access |
| accesscreate | char(1) | with null | Flag to specify securing of create access |
| accesscontrol | char(1) | with null | Flag to specify securing of control access |
| definitionmode | char(1) | with null | Not currently used |
| createdate | integer | with null | The date the object was created. |
| createtime | integer | with null | The time the object was created. |
| createsource | varchar(32) | with null | The source used to create the object |
| createnode | varchar(64) | with null | The node used to create the object |
| createuser | varchar(32) | with null | The user name used to create the object |
| createpid | varchar(5) | with null | Expires int, (The expiration date for this rule) |
| updatedate | integer | with null | The last date the object was modified |
| updatetime | integer | with null | The last time the object was modified. |
| updatesource | varchar(32) | with null | The last source used to modify the object. |
| updatenode | varchar(64) | with null | The last node used to modify the object. |
| updateuser | varchar(32) | with null | The last user name used to modify the object. |
| updatepid | varchar(5) | with null | The last process identifier used to modify the project. |
Product Name: Unicenter Network and System Management/Security
Table Type: Table