Database Software

Hello ,


is there any way of hiding CC details from all users in db level except specifc users

enrypting cc data like oracle hashed passwords


for ex,
case (1)
user 1 ( has access to these details )

select acc#,customer_name from cc_details

output : it will show all the details decrypted

case (2)

user 2 : ( doesnt have access )

select acc#,customer_name from cc_details

output : it will show all the details encrypted


both in db level , like using sqlplus or toad


any idea!

thanks and regards,