Solved

IFS 9 Database read only user for

  • 15 November 2022
  • 29 replies
  • 218 views

Badge +3

I have created  a permission set for grant selection only for all while RMB on 

 

 

 

 

but when i am query accouting tables , the data doesnt show up in table only header is visible

icon

Best answer by Link 15 November 2022, 11:23

View original

29 replies

Userlevel 5
Badge +12

Did you state is correctly that you’re querying a TABLE?

you can not directly grant access to tables from IFS applications. instead it will be always the VIEW. I have seen RMB > grant all, Grant query all sometimes misses couple / more objects hence always good to drill down more specifically through the components tree 

Userlevel 7
Badge +21

Hi @yasirB 

if the user can see the screen but can’t access to data then check the accounting rules and general ledger in the user:

 

 

 

Badge +3

bascially, i need a database read only user to access all the data for reporting purposes,

i have tried granting selection to all objects but it's not working.

 

 

Userlevel 7
Badge +21

Can you post a screenshot of the accounting table you mean?

Badge +3

in this case, any table/view that has a transaction is not showing any data

 

 

Userlevel 7
Badge +21

The permission set should be correct. Did you grant company and site in user?

Something in user isn’t complete.

 

Badge +3

I think that might be it, I have done it from front end and it seems to be working fine

 

now I have another user that is only DB user, how can I give the same right from the database side?

 

thanks a lot

 

Userlevel 7
Badge +21

Hi @yasirB 

great to read that.

I am afraid I didn’t catch your last question. Could you be more specify, please?

You have a user for DB only. Now you want to grant him (DB user) database permissions?

 

Badge +3

i have a DB user who is having same issues,this user is read-only access to all database

but whenever i am accessing any transaction tables/views, there is no data coming up.

so i believe this user needs to be granted access to companies and site as you have suggested for the user that is created on IFS front end.

now i am looking for a query that can give access to companies and site to the user that i have created in DB.

Userlevel 7
Badge +21

OK, I see.

But why do you need a query?

You can grant the permissions directly in IFS:

 

Badge +3

yes, thanks a lot for that i understood by your previous reply.

 

but i am also looking from the DB side any hint on that?

 

Userlevel 7
Badge +21

So you want execute a sql query to assign a company and site?

Then you need to create a query to insert new rows in the tables.

Here the views:

Select * from ifsapp.USER_FINANCE

Select * from ifsapp.USER_ALLOWED_SITE

Badge +3

So you want execute a sql query to assign a company and site?

Then you need to create a query to insert new rows in the tables.

Here the views:

Select * from ifsapp.USER_FINANCE

Select * from ifsapp.USER_ALLOWED_SITE

thanks a lot

Badge +3

where i can get details if GL and TB views/tables?

Badge +3

OK, I see.

But why do you need a query?

You can grant the permissions directly in IFS:

 

the user i have created with this procedure has limited access to views/tables while logging into DB from DB tool

Userlevel 7
Badge +21

Hi @yasirB 

what kind of details do you need and what do you mean with GL and TB?

Badge +3

Hi @yasirB 

what kind of details do you need and what do you mean by GL and TB?

I am trying to access the table through SQL developer using the Read-only user that I have created following above

IFS GL Voucher rows screen shows a View that i am trying to query from database but it is coming empty

Userlevel 7
Badge +21

Hi @yasirB 

could you check the authorize classes?

If they are missing you can’t see the GL vouchers.

Badge +3

is it possible to see the sql query behind quick reports?

Userlevel 7
Badge +21

Hi @yasirB 

of course. In IEE you can do the follwing step.

Go to Quick Reports and click with RMB on Show Details:

 

The details screen will show you the sql code.

Badge +3

Hi @yasirB 

of course. In IEE you can do the follwing step.

Go to Quick Reports and click with RMB on Show Details:

 

The details screen will show you the sql code.

thanks .

 

what about order reports ? for exmple customer_legder_age_analysis  sql query ?

Userlevel 7
Badge +21

You can start the debug console and execute the report. Then you can check the code in the debug console. I don’t know if you will find the right information.

Badge +3

You can start the debug console and execute the report. Then you can check the code in the debug console. I don’t know if you will find the right information.

what is the key for starting the debug console ? 

Userlevel 7
Badge +21

You can start it as follows:

 

Badge +3

You can start it as follows:

 

i dont see file menu , how to get it?

Reply