topic Re: Hide Database Table Contents in Application Development and Automation Discussions

Hide Database Table Contents

Former Member — Mon, 30 Oct 2006 07:39:43 GMT

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

Re: Hide Database Table Contents

seshatalpasai_madala — Mon, 30 Oct 2006 07:49:38 GMT

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

Re: Hide Database Table Contents

Former Member — Mon, 30 Oct 2006 07:55:36 GMT

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

Re: Hide Database Table Contents

seshatalpasai_madala — Mon, 30 Oct 2006 08:02:38 GMT

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

Re: Hide Database Table Contents

Former Member — Mon, 30 Oct 2006 08:07:36 GMT

Hi Sesh..

Got it Buddy.

Thanks And Regards.

John.

Re: Hide Database Table Contents

Former Member — Mon, 30 Oct 2006 08:12:26 GMT

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