Solved

Database access

  • 14 September 2022
  • 2 replies
  • 375 views
C
Rank
Userlevel 3
Badge +8

Hi everybody,

 

We using IFS APPS 10 and we need a user to be able to access data through our ODBC excel’s, but not be able to do anything in IFS APP, so basically it would be a readonly access to the database.

 

Is there a user already predefined for this, or is there a possibility to create a user which only has access to database objects, but not to presentation objects?

 

Or is there any other way of going about this?

 

Thanks in advance for you help!

Carlos Mendes

icon

Best answer by Sajith D 15 September 2022, 00:34

View original

2 replies

S
Rank
Userlevel 7
Badge +21

Hi @carlosfmendes ,

You can create a new permission set in the application that has read only grants to the DB objects. This can be done in the database tab in the permission set window. You will also need to grant access to the FND_RUNTIME role to this new permission set to get the basic connectivity grants. Please make sure that you setup access to company/site (and any other thing that you want to the users to be able to query that has row level security)

If you really want to prevent the user from accessing the front end application after this, you can simply change the directory id in the user creation screen for this user to null or some random value. This  will stop the user from being able to login to the app while allowing the backend database connection using ODBC.

Cheers.

C
Rank
Userlevel 3
Badge +8

Thanks @Sajith D for your suggestion.

 

I created the new permission set, but didn’t give FND_RUNTIME.

Gave access through DB permissions and all is working so far.

Reply


Terms & ConditionsCookie settings