Skip to main content
Question

How to grant DB (database) objects in IFS Cloud-versions?


Forum|alt.badge.img+2

Is there a way to grant database objects to permission sets in IFS Cloud-versions?
Or is there a way to find out the Projection granting a specific DB-object?

For example we get an error message saying:


‘Must have the right to execute method [MPCCOM_ACCOUNTING_API.TRANSFER_TO_FINANCE] to be able to create a new batch schedule.’

The correct Projection to get rid of the error may be ‘TransferInventoryTransactions’…

7 replies

Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1169 replies
  • June 15, 2022

Hi @Tom Penttinen 

grant database objects (like IEE) in Aurena isn’t possible.

Maybe you can check the screen “Projection Grans” in Aurena to find out something like this.


Sangeetha Jayamaha
Hero (Employee)
Forum|alt.badge.img+7

Hi @Tom Penttinen 

 

Please check the following link in IFS Technical Documentation. 

 

https://docs.ifs.com/techdocs/22r1/030_administration/010_security/020_permission_sets/

 

May be you find some useful info. 

 

Thank You,

Best Regards,
Sangeetha Jayamaha.

/


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Employee)
  • 7 replies
  • November 10, 2022

Hi @Sangeetha Jayamaha,

Thank you for the answer. Unfortunately the documentation you refer to does not cover how to grant database-objects or how to find the projection ultimately granting a specific DB-object.

BR,

/Tom


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 8 replies
  • June 5, 2024

Also experienced this issue. How do you identify the relevant permission set that provides the grant to database objects?


AvinduHendawitharana
Hero (Partner)
Forum|alt.badge.img+8

Hi All,

We had the same issue and we are not exposing the database APIs we deployed using direct projections. We use an utility package and call those using external file transactions.

I had to manually granted permission using database script.

 

Will this be added later in IFS Cloud or if it is not the case can we get any work around for this? There can be situations were we call database APIs without using projections specifically when it comes to the external File assistant.

Thanks and Regards,
Avindu

 


Forum|alt.badge.img+19
  • Superhero (Employee)
  • 488 replies
  • November 4, 2024

Seems like it is a database task and those can be granted here:

 


AvinduHendawitharana
Hero (Partner)
Forum|alt.badge.img+8
Tomas Ruderfelt wrote:

Seems like it is a database task and those can be granted here:

 

Thanks Tomas, That might be an option.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings