Get Username and verify the username using sql
Hi, i'm new to APEX, i want to get window login name and check again the database in APEX.
I place my javascript at header where it can get window login name
{color:#008000}<script language="javascript">
var wshshell=new ActiveXObject("wscript.shell");
var username=wshshell.ExpandEnvironmentStrings("%username%");
</script>
{color}{color:#000000}and i want to verify the username with the database, how should i do that? Want to check whether the login user is valid user or not.
I been thinking using PL/SQL procedure to do the work but where should i put it and how i gonna reference it.{color}