ADD SIGNATURE

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.

Example

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

Related commands:

sys.crypt_properties
DROP SIGNATURE
Equivalent Oracle command: ALTER USER USING AUTHENTICATION...


© Copyright SS64.com 1999-2014
Some rights reserved