SQLPROMPT5.3 decryption tests on various cryptographic objects

Original: SQLPROMPT5.3 decryption test for various cryptographic objects

SQLPROMPT5.3 decryption tests on various cryptographic objects

Test environment:

SQL2005 Personal Developer Edition SP4

Sqlprompt version: 5.3.8.2

View

1 CREATE VIEW AA 2  with Encryption 3  as 4 SELECT *  from [dbo]. [Users]

Can decrypt

Stored Procedures

1 CREATE PROCEDURE BB 2  with Encryption 3  as 4 SELECT *  from [dbo]. [Users]

Can decrypt

Trigger

1 CREATE TRIGGERcc2  on [dbo].[Users]3  withEncryption4  for INSERT5  as RAISERROR(500001, -,Ten)

Triggers cannot be called manually, so they cannot be decrypted

Function

1  Use [Pratice]2 GO3 CREATE FUNCTION [dbo]. F_get_page (@page_num BINARY(6))4 RETURNS VARCHAR( One)5  withEncryption6  as7 BEGIN8 RETURN(CONVERT(VARCHAR(2),(CONVERT(INT,SUBSTRING(@page_num,6,1))*POWER(2,8))+9(CONVERT(INT,SUBSTRING(@page_num,5,1))))+':'+Ten         CONVERT(VARCHAR( One), One(CONVERT(INT,SUBSTRING(@page_num,4,1))*POWER(2, -))+ A(CONVERT(INT,SUBSTRING(@page_num,3,1))*POWER(2, -))+ -(CONVERT(INT,SUBSTRING(@page_num,2,1))*POWER(2,8))+ -(CONVERT(INT,SUBSTRING(@page_num,1,1))))) the END

Can decrypt

If there is a wrong place, welcome everyone to shoot brick O (∩_∩) o

SQLPROMPT5.3 decryption tests on various cryptographic objects