Forum Discussion
OS user as parameter?
Hi, Is there a way we can pass user name in query so each user can download data from a table based on this parameter while user should not be able to change the query. We have oracle database and da...
Hi,
Thanks for the reply and these filter are for data filteration by I want user id as parameter for data security. So will develop a dashboard and will share with all users and once they will connect will get their own data based on their OS user passed to query. Is there a way to get current OS user as environtment variable or any other way so can use in query like
select name, amount from sales where user_id = username()
thanks
Have you been able to get any luck on your request? I'm looking to do the same thing with my company.