Skip to Content
avatar image
Former Member

ST04 - SQL EXECUTE IN BUSINESS TABLES - UNSAFE

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 15, 2017 at 12:44 AM

    Hi Jurandyr,

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

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2017 at 07:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 16, 2017 at 12:27 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 16, 2017 at 02:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded