Skip to Content
avatar image
Former Member

How to Restrict a user to a access a particular table

HI ,

how to restrict an user to a one particular table and he should have only dispaly authorization for that , can anyone suggest me how to do this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 01, 2010 at 06:10 PM

    Hi,

    Is it a standard table ? S_TABU_DIS (Client Dependant) and S_TABU_CLI (Cross client) are the the authorization objects that controls table maintenance. With Authorization group and activity 03, you can give user access only to Display.

    You can look at table TDDAT to find the authorization group of the table. If it is a custom table for which original t-code is SM30 ( You can look at SU24 to verify that) and it does not have authorization group assigned to it, then you can ask your developer to assign authorization group to the table using t-code SE54. then again make use of S_tabu_dis with activity 03 and Auth group as designed to restrict access.

    Also something to look for is Note 1481950 - New authorization check for generic table access using new auth object S_TABU_NAM. Remember Bernhard talking about it.

    Edited by: Nishant Sourabh on Oct 1, 2010 8:13 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You can define your own authorization group for this table using t-code SE54 and then secure it with S_TABU_DIS. Or you can read and implement SAP Note 1481950 which defines the concept of new authorization object S_TABU_NAM which has two fields Activity and TABNAME ( table or view to be checked) but this object is valid for SAP_BASIS 700 and not for 640.