Subject Re: [firebird-support] Firebird 3.0 grant to VIEW with GTT not working
Author DougC
Post date 2017-11-06T14:24:41Z
Brian-

Sorry, I do not have any insights on this problem. I am curious, however, what you intend with that join:

join current_organisation co on exists(select 1

                                                          from user_organisation uo

                                                          where uo.ib_username = p.logon_user_name

                                                          and uo.parameters_organisation_no = co.parameters_organisation_no)

 

Why code it this way? What are you trying to achieve? As you indicate, looks bizarre.

Thanks!

Doug C.