Hi Guys,
I would be nice to give all members of the db_owner role access to all data in secured views. This way report designers can use the view even though they are members of db_owner. You could have a flag 'Give duo full access' for example.
You could simply add OR IS_ROLEMEMBER('db_owver') = 1 at the end of the view definition.
Regards,
Lars