@Jeremy Green you need to create the view using developer studio view file. This will create the view comments needed for the dictionary cache. If these view comments are not there the view will not be added to the dictionary. The grants are checked in the dictionary. Please try by creating the view using Developer Studio. “if this datasource already exists or is created by importing a datasource .xml, it works just fine, so the system clearly DOES have access to the view.”. The datasource mentioned here is using the PRESALES_TEST view? We added the view validation check in the datasource designer before fetching columns for the view. If you try to add a column to the datasource do that work or do you get the same error as above? ps: @LakmaliRD maybe we can take a call with Jeremy. That would be quicker to clear things out.
pps: @Jeremy Green you will also need to refresh dictionary cache
Hi Jeremy; The new view needs to be given grants to IFSSYS user. The middle tier will connect to the DB using IFSSYS user to fetch the view definition to retrieve the columns to display. This is not a change done in 21R2.regards,Ramilaps: After the removal of Oracle users granting access to view is not possible. Therefore datasource role based grants for end users are handled solely through presentation object security in cloud.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.