How to hide the source code to be viewed from components (AED, CED, TCC)?

For security reasons you may want to hide the source code so that it may not be viewable from CAST components.

The source code is contained in the table "dss_code_sources" in local schema and "dss_source_texts" in central schema.One solution is to make a "truncate" on both tables, but the impact of this solution is to have errors instead of the source on the CED the AED ...!

A better solution is to replace the contents of the viewed source code with something like "this source is not available for security reasons ... "

We suggest the following updates:

1. On the knowledge schema:

UPDATE dss_code_sources
SET source_code = ' This source code is not available for security reasons… '

2. On the central schema:

UPDATE dss_source_texts
SET source_text = ' This source code is not available for security reasons… '

PS: Before performing the actions above make sure to take a backup of the knowledge and central schema

Amine Benarbia February 04, 2019 14:34

Official comment

Hi Amine,

Before updating the two tables in central and local base don't you think it would be good idea to create a temp table (like temp_dss_code_sources or temp_dss_source_texts) and copy the source code on those table and then update the table with the queries you have mentioned above?

Doing this in future if we require the source code back we can just copy the source code from temp table created above to the actual tables?

Kumar Pallava February 05, 2019 17:30

Please sign in to leave a comment.

Date Votes

2 comments

Hi Pallava,

I prefer to take a backup of local and central schema (or the 2 tables). For 2 raisons

1. What if the user decide to provide the schema to somebody? Even if the data is not shown from the component still the data are present in the schema!

2. What if you migrate your triplet? Is there any control on what are the default tables? I don't know! So I prefer to take the backup :)

Amine Benarbia February 05, 2019 17:38 0 votes