Session State Protection (SSP)
To secure the application against potential misuse by users who are intentional or unintentional.
Virtual Private Database (VPD) / Fine-Grained Control (FGAX)
Access controls at the database level, rather than at the application level
f:p=App:Page;Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly
Thursday, July 16, 2009
topics
(possibly JDeveloper and security).
XML parsing and the Senate data.
Security - database vs applications
Testing
Supporting Production Applications
Production Promotions
Wednesday, July 15, 2009
Login Page
to do this through Shared Components:
1 - Go to Shared Components
2 - Select Images
3 - Click Create
4 - In the Application option, leave it as "No Application Associated" if you want any application to use the image, or select an application if the image is for that application only
5 - Click the Browse button, locate your image file on your machine and click Open
6 - Any any Notes you want (this is not required)
7 - Click Upload
On your page, decide where you want the image to appear. This can be in a region's Source, Region Header or Region Footer OR if you want you can do this on the page template you are using. Then enter in:
For an image NOT associated with an application:
For an image associated with an application:
http://forums.oracle.com/forums/thread.jspa?messageID=3501716
Tuesday, July 7, 2009
PACKAGE .Function (Procedure – never return)
Sequence
Trigger
PACKAGE .Function (Procedure – not return )
in package, Return cursor
RETURN CHECK_USER_ROLE (V('APP_USER'),'***J_FIELD_TECH_RL')
http://forums.oracle.com/forums/thread.jspa?messageID=547397
Not
<>
!=
not
IN operator
To specify multiple values in a Where clause
MAX() function
returns the largest value of the selected column.
The outer join marker (+) signals the DBMS to insert a NULL value for the fields in the outer table that do not have matching rows in the inner table.
upper function converts all letters in the specified string to uppercase
the instr function returns the location of a substring in a string
the NVL function lets you substitute a value when a null value is encountered.
Trigger
PACKAGE .Function (Procedure – not return )
in package, Return cursor
RETURN CHECK_USER_ROLE (V('APP_USER'),'***J_FIELD_TECH_RL')
http://forums.oracle.com/forums/thread.jspa?messageID=547397
Not
<>
!=
not
IN operator
To specify multiple values in a Where clause
MAX() function
returns the largest value of the selected column.
The outer join marker (+) signals the DBMS to insert a NULL value for the fields in the outer table that do not have matching rows in the inner table.
upper function converts all letters in the specified string to uppercase
the instr function returns the location of a substring in a string
the NVL function lets you substitute a value when a null value is encountered.
Friday, July 3, 2009
Subscribe to:
Posts (Atom)