Since everyone is coming in with different IDs, this should be easy enough. Create a role in the database for all of the other logins. Deny access to the table for this role. Ideally, you can create a role for the other person (in case he gets an assistant), and grant permissions to that role on the table.
Right, I wanted to create a new database role called, Test, and assign one person to this role, then assign this role to the table, so that this one person can access the table, and deny the public role to this table. But, in denying the public role, seems like only a sysadmin can access the table.......so how does creating the role test work? For the best way to go about this....What are the steps to deny everyone in the database access to the table, except one person?