topic Re: Query and table's authorization in Application Development and Automation Discussions

Query and table's authorization

Former Member — Fri, 26 Oct 2007 08:47:14 GMT

Dear all,

I create a Query under User 'AA', and assign User "BB" to the same user group.

But when I login with User "BB" and run the query, It told me that :

You have no authorization to read the table SPFLI.

So,Which right must I assign to user "BB"?

Thanks you

Former Member — Fri, 26 Oct 2007 08:51:54 GMT

Hi John,

Not sure but I think you need to assign Infoset also to the user.

Regards,

Atish

JozsefSzikszai — Fri, 26 Oct 2007 08:52:01 GMT

hi John,

after the error message has appeared type /nsu53 into the command line and you'll get a list about failed authorisations.

Former Member — Fri, 26 Oct 2007 08:52:04 GMT

Go to SQ03. Check the Authorizations for both the user groups. Compare and based on the differences find out what is causing the error.

SQ03 --> Enter user group ..> click Assign infoset to user group...

Assign tht infoset to user BB.