Block a user from Executing system Query

[Former Member]

Dear Experts,

How to block a user from executing SYSTEM Query? Can I hide queries in System folder?

Regards,

Richard

[Former Member]

Thank you Gordon,

I'll do it in the near future.

[former_member186095]

Dear Richard,

It is also available PL48 of SAP B1 2005A SP 01 PL48. It is the latest patch. It would be better to upgrade to the latest patch.

Rgds,

"Cendana Indopearls"

[Former Member]

Hi, jimmy michael.

in This PL 48 for 2005B is there any provision to Restrict

Users only there related Project Reports they can view

remaining Projects Transaction they won't saw Reports all

Related to SAP B1 Deafult Reports. my main intension is i

want to Block Project wise Reports based on User. is it

Possible ? in SAP B1 there is no option for Field Level

Authorization. through SDK only is it Possible. Give me your

Advise .

Regds,

Samapth Kuamr devunuri.

[Former Member]

Thanks, but I tried it before without success. I set the authorization to 'no authorization' but the user still can see and execute the query.

regards,

[Former Member]

Hi Richard,

This problem has been fixed at PL46 for 2005A version or PL41 for 2005B. You probably need to upgrade your B1 if you need to block unauthorized user.

Check SAP notes 1035482 & 1173514.

Thanks,

Gordon

[jitin_chawla]

Hi Richard,

You can check this thread if the issue is similar to your case :

Regards,

Jitin Chawla