Add a digital signature to a stored procedure, function, trigger, or event notification.
Syntax ADD [COUNTER] SIGNATURE TO class::module BY crypto_list [,...n] crypto_list: CERTIFICATE cert [WITH PASSWORD = 'password'] CERTIFICATE cert WITH SIGNATURE = signed_blob ASYMMETRIC KEY Asym_key [WITH PASSWORD = 'password'] ASYMMETRIC KEY Asym_key WITH SIGNATURE = signed_blob Key module Stored procedure, function, trigger, or event notification. cert The certificate used to sign the stored procedure, function.. password To decrypt the private key. signed_blob Allows shipping a module (as a blob) without including it's private key.
ADD SIGNATURE FROM MyDatabase.MyStoredproc
BY CERTIFICATE MyCertificate;
"If only God would give me some clear sign! Like making a large deposit in my name at a Swiss bank" - Woody Allen
Equivalent Oracle command:
ALTER USER USING AUTHENTICATION...