In the previous example, it was assumed that the role value was determined from the CustomSettings.ini file. Instead, it may be more useful to retrieve the value from the BDDAdminCore table defined by the default BDDAdminDB database setup. Unfortunately, this table does not include a Role column, so this needs to be added. use [BDDAdminDB]
go
ALTER TABLE [dbo].[BDDAdminCore] ADD COLUMN [Role] [nvarchar] (50)
go
ALTER TABLE [dbo].[BDDAdminBackup] ADD COLUMN [Role] [nvarchar] (50)
go Once this column has been added, it can also be added to the AdminDB hypertext application (HTA) so that it is displayed while editing the contents of the BDDAdminCore database table. This can be done by editing the included BDDAdminDB.config file to include the new Role column in the list of columns included in the ColumnsHeaders list.
| 
