Skip to Content
avatar image
Former Member

Table access restriction to certain users

Hi,

How to restrict the particular user in accessing the database tables ?

For example: A user should not be given the the rights to access the table AUFK.

Thanks in advance.

Regards,

Harsha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 10, 2010 at 07:08 PM

    Hi,

    If you are talking about access of table through SM30, it can be done by authorization object concept. You can assign the appropriate authrization object while creating the table maintenance. Basis will assign the roles to the user. If it is SE16/SE16N then you need to create parameter transactions for each table user is allowed to view.

    Other generic option is, You can develop a report program and display the tables allowed for the user. On clicking the table name, you can take to SE16 screen. (You may need to create a transaction variant for se16/se16n for disabling the table name input field to control the user not to access other tables). Tables allowed for the user can be maintained in a Ztable.

    Thanks,

    Vinod.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2010 at 11:53 AM

    This can be done by Authorizations which is done by BASIS Team

    Regards

    Vinod

    Add comment
    10|10000 characters needed characters exceeded