Table access restriction to certain users

[Former Member]

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]

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

Regards

Vinod

[Former Member]

Thanks Vinod for the reply.

Could you pls eloborately tell me the procedure how BASIS team give authorisation to restrict users in accessing tables?

Thanks

Harsha

[Former Member]

Check this link

[http://help.sap.com/saphelp_nw04s/helpdata/en/52/67129f439b11d1896f0000e8322d00/content.htm]

Regards

Vinod

[vinod_vemuru2]

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.