6 Replies Latest reply on Mar 31, 2017 1:48 PM by Sax

Location Based Security - Folder Access

Sax Mar 30, 2017 4:07 PM

Hello All,

We have just started using Location based security in FDMEE (11.1.2.4.210.012) and encountered an issue whereby users cannot see the inbox folder structure on the FDMEE server either through the Data Load Workbench or a Data Load Rule.

The location security groups have been created with the Intermediate 2 access given. Currently I2 has just 'Data Load Workbench' assigned although we have tried various levels of access for the role however none resolve the issue.

The user has been given access to the group and when logging in they can see only the location which access has been provided for. The issue comes when they try to load data through the workbench.

They select the 'Import' however none of the Inbox/Outbox folders are seen on the server. We have an automated job which picks up files placed in the folder and then processes them so it's important that the user can place a source file in the folder.

Any ideas? We've tried all different levels of access without giving them 'admin' access.

Many Thanks,

Ross

Import Step.JPG 18.6 K

1. Re: Location Based Security - Folder Access

USER1211 Mar 30, 2017 4:22 PM (in response to Sax)

Are you stating that when you log in as an ADMIN you also do not see any of the folders for the location?

The belief is you have the applicable [Create location folder] option set to YES?
Like Show 0 Likes(0)

Actions
2. Re: Location Based Security - Folder Access

JohnGoodwin Mar 30, 2017 5:01 PM (in response to Sax)

If the application folder does not exist for the location then the user will not see anything.

If the location folder exists then the user should see the folder
Cheers

John
Like Show 0 Likes(0)

Actions
3. Re: Location Based Security - Folder Access

Sax Mar 31, 2017 12:45 PM (in response to JohnGoodwin)

Hi JohnGoodwin,

Thanks for the reply. The application folders were created when creating the target app / location.

If I log in with my admin user ID I can see the required folders:

Thanks,
Ross
Like Show 0 Likes(0)

Actions
4. Re: Location Based Security - Folder Access

Sax Mar 31, 2017 12:47 PM (in response to USER1211)

Hi USER1211,

When I login as admin I can see the folders.

The user who has been assigned Intermediate 2 cannot.

Thanks,
Ross
Like Show 0 Likes(0)

Actions
5. Re: Location Based Security - Folder Access

JohnGoodwin Mar 31, 2017 1:05 PM (in response to Sax)

Where has your inbox folder gone? if I start changing the folder structure from what FDMEE expects then the user doesn't see the folder.
please test with \inbox\locationname folder structure
Like Show 0 Likes(0)

Actions
6. Re: Location Based Security - Folder Access

Sax Mar 31, 2017 1:48 PM (in response to JohnGoodwin)

Thanks JohnGoodwin,

I recreated the inbox folder and created a few folders within and then the user can see all folders required.

I was hoping to not have to have the Inbox folder as this Location won't be used for actually loading data however seems it is a must.

Thanks for your help,
Ross
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.