topic Validate user for ztable access in Application Development and Automation Discussions

Validate user for ztable access

Former Member — Thu, 17 May 2007 04:57:22 GMT

Hi,

I have a program to upload data to ztable from excel.

In my selection screen, i need to validate if the user is authorized for ztable maintennace.

Please send me some code, if any one has.

Thanks in advance

Re: Validate user for ztable access

Former Member — Thu, 17 May 2007 05:01:12 GMT

The following actions are subject to authorization checks that are performed before the start of a program or table maintenance and which the SAP applications cannot avoid:

Table maintenance with generic tools (S_TABU_DIS)

You can also assign authorization groups to tables to avoid users accessing tables using general access tools (such as transaction SE16). A user requires not only authorization to execute the tool, but must also have authorization to be permitted to access tables with the relevant group assignments. For this case, we deliver tables with predefined assignments to authorization groups. The assignments are defined in table TDDAT; the checked authorization object is S_TABU_DIS.

rgds

Deepak.

Re: Validate user for ztable access

Former Member — Thu, 17 May 2007 13:36:41 GMT

I have to validate the users, before i run the upload program.

Please send me some code to check if the user is valid user inside the authorization group of that table

i need some checking like this

select username from table in authorization group....

Re: Validate user for ztable access

amit_khare — Thu, 17 May 2007 13:42:19 GMT

Use this FM - AUTHORITY_CHECK

Regards,

Amit

Reward all helpful reply

Re: Validate user for ztable access

Former Member — Thu, 17 May 2007 13:44:31 GMT

Select the data from Table USR04 Table do the validation

Re: Validate user for ztable access

Former Member — Thu, 17 May 2007 17:23:48 GMT

Can you please explain what i need to check from this table

I need to check if user is in authorization group for ztable.

Re: Validate user for ztable access

Former Member — Thu, 17 May 2007 17:43:53 GMT

select * from usr04 into usr04

where bname = sy-uname

and PROFS = 'Profle'.

if sy-subrc ne 0.

message 'no authrization'

endif.

Reward Points if it is helpful

Thanks

Seshu

Re: Validate user for ztable access

Former Member — Thu, 17 May 2007 18:11:21 GMT

also check the usr07 table