topic Re: Table Security in Application Development and Automation Discussions

Table Security

Former Member — Thu, 11 Jan 2007 18:08:19 GMT

HI All,

How to implement security to tables. in sap r/3.Can anybody done this type of project.Please give the detail procedure how to implement this.

Thanks

Regards

Re: Table Security

Former Member — Thu, 11 Jan 2007 18:40:35 GMT

Hi,

In one of your earlier post you have similar question.

If other than this what exactely do you need?

Do you want to restrict user from accessing to tables?

Then check for the T-Codes in which roles they have been assingned and who has authorization and restrict them as per your requirement.

Cheers

Soma

Re: Table Security

Former Member — Thu, 11 Jan 2007 19:54:20 GMT

Hi Soma,

I have to conduct the analysis, prepare a design solution, then present it with estimates as to what it will take to complete.

Thanks

khaiser.

Re: Table Security

Former Member — Thu, 11 Jan 2007 20:29:57 GMT

Hi,

Exactely If you want to proceed to restrict. You need to analyse and prepare compete informatin and present to the concern person for decesion.

Cheers

Soma

Re: Table Security

Former Member — Thu, 11 Jan 2007 20:42:21 GMT

Hi Soma,

Can you please tell me step by step procedure how should i start with it.just give me a rough idea i will work .I shall be very much thankful to you.

Thanks

Regards

Khaiser

Re: Table Security

Former Member — Thu, 11 Jan 2007 21:33:40 GMT

Hi,

I am giving an example how to get information.

1. Use T-Code SUIM to identify roles which has T-Code SM31

In SUIM (User information screen)

Choose Role

Roles by Complex Selection Criteria

Enter the values

Role *

Authorization Object: S_TCODE

T-Code SM31.

Authorization object: S_TABU_DIS

Activity: 02 AND 03

Download List.

2. Use T-Code SUIM to identify users who has T-Code SM31

Activity: 02 AND 03

Download List.

3. Provide the all the information to the concern person and follow as per their instruction.

Cheers

Soma

Re: Table Security

Former Member — Fri, 12 Jan 2007 14:10:54 GMT

Hi Soma,

Thanks very much .In your last answer i am some what confused .Can Please explain once again in detail how to take out roles in suim and how to take out user in suim.(with respect to my situation).

Thanks

regards

Khaiser

Re: Table Security

Former Member — Fri, 12 Jan 2007 16:48:50 GMT

Hi,

Enter SUIM

You will be displayed with list of options

Users

Roles

Profiles

>Click on Roles (Open)

You will be displayed with following options

Roles by Complex Selection Criteria

By Role Name

By User Assignment

Click on clock icon beside Roles by Complex selection...

In the next screen you will be displayed with input boxes

Enther the values which I had mentioned in earlier post.

In the Tab below you need fill the following information enter the object and click on enter value button.

Selection by Authorization Vaues

Object1 S_TCODE

T-Code SM31.

Object2 S_TABU_DIS

Activity: 02

AND 03

Then click on (F8) or click on the top clock icon.

You will be displayed with list of roles.

Hope now clear

Cheers

Soma

Re: Table Security

Former Member — Mon, 15 Jan 2007 13:54:40 GMT

Hi Soma,

Do i also need to take out for se16,se17,sm30.As you said for sm31.

Thanks

Regards

Khaiser

Re: Table Security

Former Member — Mon, 15 Jan 2007 13:57:53 GMT

Hi Soma ,

I have one more question ,I have to take out reports in dev or qa or prd.

Thanks

Regards

Khaiser

Re: Table Security

Former Member — Mon, 15 Jan 2007 14:23:05 GMT

Hi Soma,

How to download users with sm31 and activity 02 and 03.

I shall be thankful and obliged to you.

Regards

Khaiser

Re: Table Security

Former Member — Mon, 15 Jan 2007 16:24:39 GMT

Hi Soma ,I have one more question,

how to create a transaction to run RBDAPP01 to manually force the job that brings idocs into staging.

Thanks

Khaiser

Re: Table Security

fredrik_borlie — Mon, 15 Jan 2007 16:44:33 GMT

> Hi Soma,

> I shall be thankful and obliged to you.

> Regards

> Khaiser

Kaiser. By giving the ones that provide you with relevant answers some points is the best way to show them that you appreciate their time of solving your problems.

You find it to the left of every answer in this thread.

Regards

Fredrik

Re: Table Security

Former Member — Wed, 17 Jan 2007 14:05:50 GMT

Hi Khaiser,

Did you manage to get all the reports in PRD.

Cheers

Soma