2

Secured View

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

0 comments

Please sign in to leave a comment.