Hide Database Table Contents

[Former Member]

Hi,

I need to hide a database table contents.

I have created a ztable that contains the usernames and passwords, Now i don't want anyone to view its contents via transactions se11 or se16.

Please reply

John

[seshatalpasai_madala]

Hi,

If you select no maintanance allowed in the Delivery and maintanance tab of table display tool (SE11). Then nobody can see its contents.

GOTO SE11->Enter Tablename->Change->Delivery and Maintanance tab, Select Maintanance not allowed.

Regards,

Sesh

Message was edited by: Seshatalpasai Madala

[Former Member]

hi sesh ,

I got your point, but will I be able to create new entries in the table or not if I select display/maintainence not allowed?

reply please.

john

[seshatalpasai_madala]

Hi,

No you will not be able to create entries using SE11 or SE16 you need to create a program of your own to create entries into that table which is not a big task.

You just need to lock the table first then save the entries into the table using INSERT then unlock in your program. Yo ucan create screen for that easily in the screen painter by using get fileds from dictionary.

Reward helpful answers

Regards,

Sesh

Message was edited by: Seshatalpasai Madala

[Former Member]

Hi Sesh..

Got it Buddy.

Thanks And Regards.

John.

[Former Member]

Hi,

I dont think you need to worry about the person's restrictions to see the table..

I believe you will be using the concept of authorisation roles...person authorised to 'se11' only can change or view the data...others can be resticted...usually implemented by a BADI..

Most probably you will be creating a view and a transaction code for the view...based on authority checks you can allow/restrict user to run the transation for views...again through BADI

Hope you found the information useful........

Regards

BX