cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Query Authorisation

Muralinag14
Active Contributor
0 Kudos
730

Hi,

I have created a query through transaction SQVI for the table FAGLFLEXT and assigned a transaction code. Now I want to give authorisation of this query to end users, for that we have assigned the transaction code to their roles. While executing the report from end user ID, system is giving the error message that you don't have authorisation to display the table FAGLFLEXT. But we can't give access of table display to end users.

What can be done in this situation?

Rgds

Murali. N

Accepted Solutions (1)

Accepted Solutions (1)

former_member1127250
Active Participant
0 Kudos

Hi ,

Provide display access for authorization object "S_TABU_DIS" which will enable user to excute the SQVI report .Anyways ,users can not access table or table entries as they will not have authorization for transactions SE16 ,SE11.

Kumar

Muralinag14
Active Contributor
0 Kudos

Hi Kumar,

Thanks for the reply.

S_TABU_DIS object is related to SM30, through SM30 we can see the tables which has view maintenance.

Muralinag14
Active Contributor
0 Kudos

Rakesh/Brian,

Thanks for the reply.

I know how to find the missing authorisation objects.

But the issue here is system asking authorisation for S_TABU_DIS which is related to SM30 where we can see tables.

So, we don't want to give the authorisation for SM30 and we are looking for another solution.

Muralinag14
Active Contributor
0 Kudos

The issue has been solved by assigning S_TABU_DIS authorisation object to the role.

Since we are not giving athorisation to SM30, so the user can't be able to access the table.

Answers (2)

Answers (2)

Former Member
0 Kudos

you can enter t-code su53 in command box in current screen . and maintain it manual using t-code PFCG

System will list which authorization object has been missed,

Former Member
0 Kudos

Hi Murali,

Please check this link below

http://scn.sap.com/thread/227856

I think you can group the tables in the authorization object where you can omit sm30

Thanks

Vishnu

Former Member
0 Kudos

you can enter t-code su53 in command box in current screen .

System will list which authorization object has been missed,and you can manual maintain it using PFCG.