-
encryption dilema....
I want to encrypt stored proc, trigger, role and view. And SQL could do it.
But I want to access it with some password when I need to see its content.
Any one knows SQL 2k has some similiar pwd to let you access the encrypted objects?
thanks
-D
-
why cant you use VSS or PVCS. and when implenting always encrpyt it.
-
There is shareware utility to access encrypted objects.
-
MAK and Rmiao:
thanks for the info.
I have around 1000 databases and frequently need to implement application service patch (sp, trigger, view, rule...) across 40-50 servers. The service patch implementation may take 1 day(no more than 2 days) to finish.
Thus, direct access to encrypted objects for debuging and checking the individual database sql object version is neccessary.
Which shareware software could do this?
David
-
1. For such a number of servers and databases, why you need to have additional over head of encrypting and decrypting?
2. For such a infrastructure, you will be having change management process which in turn should have atleast VSS or PVCS. So why not use the existing VSS/PVCS you have.
3. Check with your company's standard and policy before doing this
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|