Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Former Member replied

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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question