How to Restrict the database table modification?

[Former Member]

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?

[former_member213851]

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.

[ThomasZloch]

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

[Former Member]

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

[Former Member]

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