User IP Address Row Level Security

 Hi all,

I have a situation where I want to restrict what a user (sales rep) sees based on a site location. For example, if the user logs on from home or Site A, they see all sales; if they log on from Site B, they only see their sales. It's a case where the user is being mentored into a management role, but when at Site B, they don't want prying eyes (open office) to notice that they have more access than everyone else.

I was wondering if I could somehow get the IP address where they are logged on, and I could restrict what they see.

Any ideas?

Thanks

Steve