If I revoke permissions, like Select, from a field, though, my understanding is that no one will be able to retrieve the data from that field.
I need to block certain data, like SSN, from being displayed by default. If certain users have the right permissions, they will be able to see the data.
I understand putting the different users in different windows groups and giving each group different security.
I have found references of how to secure down rows in a table, applying different levels of security to the database and table, and know about encryption. My belief is that there has to be a way to secure the field.
Maybe another table that lists the sensitive field names and what level of security they need to be visible and a table of users and their level of security. If someone believes that that is possible, then my question would be how to join the "field" table to verify that the data should be displayed.