I want to create a view in my SQL geodatabase, but users don't need to see or use.
How would I create a view that users won't show up in ArcGIS products?
Just don't give the concerned users permission on that view. If the user doesn't have permissions, they won't see the View when they connect, so no question of using it.
I was hoping there would be a flag or something I could check to hide that one table only for ArcGIS products but usable by third-party connections. Most of our users connect through a group with db_datareader.
No, there is no out of the box way to do that. Database level permissions will be applicable at the ArcGIS level too. There is no way to just restrict for ArcGIS products.
Retrieving data ...