I need a view based on the user which is currently logged in my app. I have set a global variable containing this user's ID.

Can I use the content of this global variable as in:
Select * ;
from MyTable ;
where MyTbale.User_Id = MyGlobalVariable'sContent

What would be the correct syntax for the where portion of the statement so that I could extract the content of the variable ?

TIA

Pierre Richard