CODEWITHSUNDEEP
stored-proceduresencryptionteradata
Krzysztof
Krzysztof

Reputation: 25

How to encrypt stored procedure in Teradata

Is it possible to encrypt stored procedures in Teradata? I would like to hide the code of procedure from others and I have no idea if it is even possible.

Some ideas?

Thanks, Cris

Upvotes: 0

Views: 332

Answers (1)

dnoeth
dnoeth

Reputation: 60462

There's no need to encrypt the source code of a SP in Teradata, you can simply use the NO SPL option and then no source code is stored.

Either during creation using ODBC, CLI or BTEQ, e.g. in BTEQ

.COMPILE FILE 'mysp.spl' WITH NOSPL

But the common way is to CREATE it first and then run:

ALTER PROCEDURE mySP COMPILE WITH NO SPL;

Upvotes: 3

Related Questions