OraFAQ Forum: Forms » Global Security Variable???

Home » Developer & Programmer » Forms » Global Security Variable???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Global Security Variable??? [message #78810]

Mon, 18 March 2002 12:20

Tyler
Messages: 123
Registered: January 2002

Senior Member

I'm trying to implement a security model... is there a global variable set in Oracle when the user signs in to the db? So on new form instance I can say ...

~pseudo~
If :Global.(User) = 'non-editable privledge' then
message('You are not allowd to edit');
end if;

Report message to a moderator

Re: Global Security Variable??? [message #78817 is a reply to message #78810]

Mon, 18 March 2002 23:49

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

1.no , there is no global security variable is set.
2.if u want to find current user then use get_application_property (username)
3. if u want to enforce security then u have to write ur logic for it

Report message to a moderator

Acces Variable OS LINUX (export variable) from PL/SQL Oracle ? [message #79551 is a reply to message #78817]

Fri, 21 June 2002 01:07

uk
Messages: 1
Registered: June 2002

Junior Member

how do we can acces variable os linux ( export variable) from pl/sql oracle ?

Report message to a moderator

Previous Topic:	Dynamically changing the datatype for a column
Next Topic:	for loop inside block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 05:17:22 CDT 2024