04-07-2010 11:59 AM
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
04-10-2010 8: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.
04-07-2010 12:53 PM
This can be done by Authorizations which is done by BASIS Team
Regards
Vinod
04-08-2010 6:17 AM
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
04-08-2010 9:34 AM
Check this link
[http://help.sap.com/saphelp_nw04s/helpdata/en/52/67129f439b11d1896f0000e8322d00/content.htm]
Regards
Vinod
04-10-2010 8: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.