Skip to Content
0

ST04 - SQL EXECUTE IN BUSINESS TABLES - UNSAFE

Mar 14, 2017 at 08:26 PM

86

avatar image
Former Member

ST04 - SQL EXECUTE IN BUSINESS TABLES - UNSAFE

Hi,

I want continue user ST04, but I don't want that users make queries in business tables.

What the object authorization I change it?

Thanks',

Jurandyr Alves

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

James Zhang
Mar 15, 2017 at 12:44 AM
1

Hi Jurandyr,

revoke the user se16 permission will disable the sql editor as mentioned in SAP note 1456771.

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 15, 2017 at 07:17 PM
0

Hi James,

If revoke SE16 permission, the sql editor in ST04 stay disable. This is really work. But I need that users have two transactions SE16 and ST04, but ST04 with sql editor disable.

The object S_TABU_DIS is value 3 in se16.

Is there any object in ST04 where I can modify value to disable sql editor in ST04?

Thanks',

Jurandyr Alves


iw0in.png (5.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
James Zhang
Mar 16, 2017 at 12:27 AM
0

Hi Jurandyr,

SE16 and sql editor together disable makes senses. SE16 can also view business table/content, if you give user se16 permission, what is the difference to give them sql editor permission?

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 16, 2017 at 02:30 PM
0

Hi James,

I have a customization where same business tables are block in SE16, but if the user have ST04 with sql editor he can make query in business tables blocks. The users can make queries in another business tables in SE16 and they need it.

Thanks,

Jurandyr Alves

Share
10 |10000 characters needed characters left characters exceeded