The DBTD_TBL_SERVER_ACCESS table contains framework access privileges for a database servers.

By default this table has no records, which means that framework functionality access is open on the server it is installed. If table have at list one record then test runners will verify if a server do have rights to run unit tests. Only ALLOWED servers will be able to use test runners, on all other servers framework test runners will not run.

Note:
 - this measure does not prevent from manually executing stored procedures

Column Name Data Type Description
ServerName VARCHAR(128)

Server name. This field can use wild characters, for example:

  • DEV% - all servers which have name starting with the substring 'DEV'
  • DEV_%_BCP - all servers whose name starting with the substring 'DEV' and ending with '_BCP'
  • PROD002 - server PROD002
Access VARCHAR(50)

Server Access:

ALLOWED - Access Allowed. 
DENIED - Access denied 

Note: Any other value besides ALLOWED will be treated as access denied.  

 

Example 

 

INSERT INTO DBTD_TBL_SERVER_ACCESS
      (ServerName, Access)
      SELECT 'DEV00%', 'ALLOWED' UNION ALL --development boxes
      SELECT 'TC%', 'ALLOWED' UNION ALL --team city build servers
      SELECT 'ZEUS002', 'DENIED' --DENY on prod