How to capture a varaible [message #81022] |
Fri, 27 December 2002 22:35 |
maha
Messages: 11 Registered: November 2000
|
Junior Member |
|
|
hi there,
i want to capture the user, if he is admin or a normal user in the forms, how can i do it?
|
|
|
Re: How to capture a varaible [message #81064 is a reply to message #81022] |
Thu, 02 January 2003 05:54 |
G.Srinivasa Rao
Messages: 7 Registered: January 2003
|
Junior Member |
|
|
declare
v_usr varchar2(20); /*stores user name */
begin
v_usr := get_application_property(username);
if v_usr ='ADMIN' then
-----
else
-----
end if;
end;
similarly to capture password and connect string
you can use get_application_property(password),
get_application_property(connect_string);
G.Srinivas Rao
|
|
|