how to encrypt data in table coloumns in sql7/sql2000.so that only users having special permissions can see(or discrypt )the data in the coloumn
the permission is given by depending on their name(let's suppose)on the same table in another coloumn.
here i dont want to encrypt all the coloumns in the table.
can anybody help me..
