Hello,
  Is it possible to have Sensitive Results with joins and/or views ?

Thank you

--
Charalampos Michael - [Creation Power] - http://www.creationpower.gr

Michael,

<< Is it possible to have Sensitive Results with joins and/or views ? >>

With joins, no, minus this caveat:

http://www.elevatesoft.com/newsgrp?action=openmsg&group=17&msg=2934&page=1#msg2934

Views are just like any other query, so yes, they can generate sensitive
result sets.  Any view that generates a sensitive result set is considered
an updateable view.

--
Tim Young
Elevate Software
www.elevatesoft.com

Dear Tim,

> << Is it possible to have Sensitive Results with joins and/or views ? >>
>
> With joins, no, minus this caveat:
>
> http://www.elevatesoft.com/newsgrp?action=openmsg&group=17&msg=2934&page=1#msg2934
>
> Views are just like any other query, so yes, they can generate sensitive
> result sets.  Any view that generates a sensitive result set is considered
> an updateable view.

Nice! I'll try it up right away!

Any chance to get sensitive JOINS in the future ?

--
Charalampos Michael - [Creation Power] - http://www.creationpower.gr

Michael,

<< Any chance to get sensitive JOINS in the future ? >>

It's on the list, but it's a bit more difficult.

--
Tim Young
Elevate Software
www.elevatesoft.com

Dear Tim,

> << Any chance to get sensitive JOINS in the future ? >>
>
> It's on the list, but it's a bit more difficult.

I understand ...

--
Charalampos Michael - [Creation Power] - http://www.creationpower.gr