0

i have made a useful scripts in my environment and i want to wrap the script same as Oracle Wrap utility can do. is there any other way to the same in sql server?

1
  • 2
    Might be helpful to link to the documentation on the Oracle Wrap utility and / or explain what it does / how it works.
    – J.D.
    Commented Oct 18, 2023 at 5:32

1 Answer 1

1

Oracle Database

Oracle's Wrap Utility is limited to encrypt only contents of the following types:

19.0 Documentation

  • Package specification
  • Package body
  • Type specification
  • Type body
  • Function
  • Procedure

Reference: PL/SQL Source Text Wrapping (Oracle | Database PL/SQL Language Reference)

Microsoft SQL Server

If you have a look at the individual CREATE ... statements for the available objects in Microsoft's SQL Server then you will observe that the following objects can be encrypted:

  1. Functions

     CREATE FUNCTION .... WITH ENCRYPTION...
    

    Reference: CREATE FUNCTION (Transact-SQL) (Microsoft Learn | SQL)

  2. Procedures

     CREATE PROCEDURE .... WITH ENCRYPTION...
    

    Reference: CREATE PROCEDURE (Transact-SQL) (Microsoft Learn | SQL)

  3. Triggers

     CREATE TRIGGER .... WITH ENCRYPTION...
    

    Reference: CREATE TRIGGER (Transact-SQL) (Microsoft Learn | SQL)

Other options for other Microsoft SQL Server objects may be available, but I guess you get the general idea.

2
  • thank you so much John for the insight. Appreciate it !
    – zul nasir
    Commented Oct 25, 2023 at 16:32
  • @zulnasir If you think my answer is helpful, then I would appreciate an accept or at least an up-vote to my answer. Thanks.
    – John K. N.
    Commented Oct 26, 2023 at 14:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.