OraFAQ Forum: Forms » how to restrict update of a block

Home » Developer & Programmer » Forms » how to restrict update of a block (oracle forms developer 10g)

Tue, 22 February 2011 01:20

coder
Messages: 13
Registered: February 2011
Location: United States

Junior Member

I want to give update rights of a block to restricted set of people... how can i achieve it???

please help

Tue, 22 February 2011 01:46

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

grant update on table_name to user_name

Regards
Athar

Tue, 22 February 2011 02:22

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Try this Sample Code.


If User in ('A','B','C') then
Set_Block_Property('Block_Name',Update_Allowed,Property_False);
End If;

Regards,
Irfan

Tue, 22 February 2011 03:29

coder
Messages: 13
Registered: February 2011
Location: United States

Junior Member

thanks

Previous Topic:	how to create button to upload pdf file
Next Topic:	Webutil Error

Goto Forum:

]

Current Time: Mon Sep 16 13:03:27 CDT 2024