by Hello
I migrate a database application from 4.9
to 11.5 on HP/UX
Everything works well with one exception:
We have Users - for example the dbo and one other User "User1"
We create a view for both users:
dbo.app_view as select * from table1 where id < 100
User1.app_view as select * from table1 where id > 100
Then we create a procedure (owner dbo, grant exec to public)
proc1
with recompile
as
select * from app_view
return(0)
In 4.9 :
dbo executes proc1 -> Resultset with id < 100
User1 executes proc1 -> Resultset with id > 100
In 11.5 :
dbo executes proc1 -> Resultset with id < 100
User1 executes proc1 -> Resultset with id < 100 !!!
...
Each User gets the resultset from the view owned
by dbo
If I select user_id() inside the procedure I receive
the correct result
I need the 4.9 behavior
Any suggestions
Thanks Axel
--
-------------------------------------------------------------------------
TOPOLOGIX
Gesellschaft fuer informationstechnische und mathematische Loesungen mbH
Grosse Bleichen 12, D-20354 Hamburg, Germany
Phone: +49 (40) 352 253 Fax: +49 (40) 340 340 http://www.TOPOLOGIX.de
Geschaeftsfuehrer: Roman Moeller, Carsten Mohr, Jens Timmermann
Amtsgericht Hamburg HRB 42932
-------------------------------------------------------------------------