I have a point feature class with several photo attachments. There are situations where I may want to filter which photos a user can/should be able to view. For instance, A user may only want to view "Finish Phase" photos and not "Construction Phase" photos. I have thought about adding a field to the attachment table and populating with the phase type. However, I don't know if there's a way to apply this filter, or definition query, to the end user. All my data and photos are stored in SQLServer.
Any ideas how I might be able to accomplish this?
I see no reason why it would not be doable? You are able to get users name / roles and if you have a foreign key within the photo table a filterable relationship could be established or handled by code.
This looked promising ... How To: Get the current user name and roles using a server object extension
Did you ever figure out how to do this? I have the same (or roughly the same) use-case. I have a feature with many photos and in the feature's popup i want to display only the pictures with the name 'before' and 'after' while not showing any others.