May 28, 2008 at 12:12 pm
How can I prevent a user to decrypt data if he can encrypt it and prevent user to encrypt data if he or she can encrypt by using symetric or asymetric,because the business rules doesn't want a same use to have both permissions.
May 28, 2008 at 4:05 pm
It depends on how you are doing the encrypting and decrypting in the first place. If your users have to run a procedure to do each thing, then restrict permissions on the procedures. If the procedures are your own wrappers around canned ones that know how to find the keys or passwords, all the better.
May 28, 2008 at 8:26 pm
How is the user coming into the database? Through an application? Using a service account?
K. Brian Kelley
@kbriankelley
May 29, 2008 at 4:44 pm
Though an application.How Can I prevent a user to use decryptbykey or encryptbykey
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply