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
Hi
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.
Thanks
I created the new permission set, but didn’t give FND_RUNTIME.
Gave access through DB permissions and all is working so far.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.