IFS 9 Database read only user for

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 

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:

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.

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

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

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

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?

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.

OK, I see.

But why do you need a query?

You can grant the permissions directly in IFS:

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?

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

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

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

Hi @yasirB 

what kind of details do you need and what do you mean with 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

Hi @yasirB 

could you check the authorize classes?

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

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

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.

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 ?

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 ? 

You can start it as follows:

You can start it as follows:

 

i dont see file menu , how to get it?