Results 1 to 7 of 7

Thread: Db2 UDB

  1. #1
    Join Date
    Aug 2002
    Posts
    3

    Post Unanswered: Db2 UDB

    Hi

    Is it possible to encrypt the stored procedures in DB2 UDB database?. If yes please let me know


    Thanks

    Kiru

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Db2 UDB

    Do you mean that none other than the db2 superuser should be able to see the Stored Procedure text in the Catalog tables ?

    If so, revoke the SELECT Privilege on SYSCAT.PROCEDURES from PUBLIC ....

    If my understanding is not right, can you please explain your requirement ...

    cheers

    Sathyaram

    Originally posted by kiru
    Hi

    Is it possible to encrypt the stored procedures in DB2 UDB database?. If yes please let me know


    Thanks

    Kiru

  3. #3
    Join Date
    Aug 2002
    Posts
    3

    Post Re: Db2 UDB

    Hi Sathyaram

    Thank you

    My question was bit different. Is there any utility which will wrap source code?. In elabrate i don't like to give my soruce to code to my client instead if there is anything which can wrap actual source code i can use it.

    Cheers

    Kiru


    Originally posted by sathyaram_s
    Do you mean that none other than the db2 superuser should be able to see the Stored Procedure text in the Catalog tables ?

    If so, revoke the SELECT Privilege on SYSCAT.PROCEDURES from PUBLIC ....

    If my understanding is not right, can you please explain your requirement ...

    cheers

    Sathyaram
    Last edited by kiru; 08-30-02 at 15:30.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Db2 UDB

    Though not 100% sure, I believe that cannot be done ...

    Maybe you can try Java or C/C++ Stored Procs ....


    Another way, that flashed into my head just this moment ...

    If you get the sqc file generated from the SQL Stored Proc, you can precompile, bind, compile/link it and then define the Stored Procedure as a C procedure ....

    I have seen the sqc files when my precompile/compile failed for some 'unknown' reason ....

    Let's see what others in the forum think ...

    Cheers

    Sathyaram

    Originally posted by kiru
    Hi Sathyaram

    Thank you

    My question was bit different. Is there any utility which will wrap source code?. In elabrate i don't like to give my soruce to code to my client instead if there is anything which can wrap actual source code i can use it.

    Cheers

    Kiru

  5. #5
    Join Date
    Jan 2002
    Location
    Manila, Philippines
    Posts
    71

    why do you want to do this ?

    i think your client owns whatever they have paid you for - that is ALL deliverables. how can your client maintain your codes if its going to be encrypted, hire you back ?

    i think this is very unprofessional and i suggest you don't do this so that you won't soon run out of clients.

    just me 2cents...

    regards,
    oliver

  6. #6
    Join Date
    Aug 2002
    Posts
    3

    Thumbs down Re: why do you want to do this ?

    Hi Oliver

    Thank you for your kind advice. . This is suppose to be DBforum not adivicing forum. Here my requirement is bit different. We selling product to client. Nothing like unprofessional...............




    Cheers

    Kiru

  7. #7
    Join Date
    Nov 2001
    Location
    Finland, Kirkkonummi
    Posts
    17
    Hello

    I guess there are a lot of us who sell products to customers.
    It does not matter if customer sees your code in their databases. The rights to the code are still in the hands of the company (or whatever entity that supplied the code) who sold the product.

    Customer can not use or reuse that code unless that is agreed with your company.

    Usually these things are resolved with contracts (more) and mutual trust (less).

    If they violate the contract then the men in black suits usually come in to play.

    Vesku

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •