Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Urgent Security issue: No Access

2695308Aug 25 2014 — edited Sep 4 2014

Hi All,

I have a requirement to create a user and assign some roles from HFM application, so

1) I have created a user and assigned the roles requested as below

Consolidate
Consolidate All
Consolidate All with Data
Create Journals
Data Form Write Back from Excel
Enable write back in Web Grid
Generate Recurring
Inter-Company Transaction Admin
Inter-Company Transaction Auto Match by Account
Inter-Company Transaction Auto Match by ID
Inter-Company Transaction Manual Match
Inter-Company Transaction Match Template
Inter-Company Transaction User
Load Excel Data
Load System
Lock Data
Manage Custom Documents
Manage Data Entry Forms

2) Provided security class to the metadata.

3) Assign access control, where i have assigned write access for Default as well as one of security class assigned for metadata.

4) While launching the security report as per roles and classes, report runs continuously till i close the browser.

5) Loggined with the newly created user and tried to create new data grid, but it was showing NOACCESS.

Can any one guide me to resolve the issue. do i need to provide any access more that this.

Thanks in Advance.
This post has been answered by user10767728 on Aug 25 2014
Jump to Answer

Comments

InoL

I am currently also working on a Forms to Apex conversion and encounter the same problems. Alas, you do have to make Ajax calls and confirm dialogs before actually submitting the page.

This (in my case anyway) means a redesign of Forms processing.  All the necessary checks need to be done before submitting the page. So, a Form proces like this:

<do something>

<confirm?>

<do something>

<confirm?>

<final commit>

has to be redesigned to

<do some checks via an Ajax call without committing data>

<confirm?>

<post and commit>

This usually means you first get all the confirmation messages back in one message instead of multiple confirms (as was usually the case in Forms).

If this kind of redesign is not possible, you should hold temporary results in a collection before actually committing the data.

BTW: it gets worse when you have Forms with a POST-FORMS-COMMIT trigger!

Niels IH

Thanks for your reply

Perhaps collections are the way to go. I would rather not offcourse.

I think it will mean that i have to rewrite the standard save action of the interactive grids to process the row(s) through ajax and handle the user interaction before they are actually submitted by the grid.

Perhaps i can come up with some plugin design to do this in a more general way..

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2014
Added on Aug 25 2014
#business-intelligence-applications, #financial-consolidation, #performance-management-applications
4 comments
1,515 views