Thursday, August 6, 2009

Hide Button


Home>Application Builder>Application 135>Page ***>Edit Button Item
Conditional Item Display
Condition Type
Never

I preferred



Thursday, July 16, 2009

Security:

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

topics


Apex and security

(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

banner



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.

Friday, July 3, 2009

Roles,Authentication Schemes, Authorization Schemes



DBA_ROLE_PRIVS, USER_ROLE_PRIVS


I doubt whether the old one working or not