topic Re: How to Restrict the database table modification? in Application Development and Automation Discussions

How to Restrict the database table modification?

Former Member — Wed, 23 May 2012 10:46:43 GMT

I have my cuztomised table zabc in which i have user name and password field .i dont want any other user except me to change the data of table from program using MODIFY or update or Insert statements to my cuztomised table zabc or any what ever modification through se11 too? How to make that possible?

Re: How to Restrict the database table modification?

former_member213851 — Wed, 23 May 2012 10:52:44 GMT

Hi Deepan,

You can restrict the acces to your ZTABLE by giving odispaly Authorization to all other UseiDs except your ID.

Use SM30 and give table/View name which you want o maintian and in su24 of the parameter transaction code [Ztcode] maintain

S_TABU_DIS activity field as you wish and authgroup field with the authorization group which is assigned for the table.

That should solve your problem

Please take help from Authorizatiion Team .

Regards Sachin.

Re: How to Restrict the database table modification?

ThomasZloch — Wed, 23 May 2012 11:03:47 GMT

With ABAP code you can change any table contents, so this seems not possible. You could speak to your DB administrator if your particular DBMS has such a feature on a lower level.

Building checks on single user names is not a good idea however, or are you planning to stay forever where you are now?

SE11 protection can be achieved via S_DEVELOP authorization object, search for information.

Thomas

Re: How to Restrict the database table modification?

Former Member — Wed, 23 May 2012 11:11:37 GMT

Tables can be modified from the report program. However Authorization objects are there which prevent from doing so and it is general authorization object for workbench objects.

Check the below links.

http://wiki.sdn.sap.com/wiki/display/SMAUTH/S_DEVELOP

http://help.sap.com/saphelp_40b/helpdata/en/27/174b6e5733d1118b3f0060b03ca329/content.htm

Re: How to Restrict the database table modification?

Former Member — Wed, 23 May 2012 12:31:06 GMT

Hi Deepan,

If you are really worried about the security of your table, try to encrypt the contents so that others cannot easily read the information without decryption.

Its just an suggestion and i have not tried it before.

Regards,

Karthik D