topic Re: Table Insert Authorization for ZTABLE in Application Development and Automation Discussions

Table Insert Authorization for ZTABLE

Karan_Chopra_ — Fri, 11 Mar 2011 10:33:01 GMT

I have a Ztable which is getting Inserted/Updated thru some Report.

I want to give Authorization for Insertion/Updation of that table through that program.

How can I proceed.

My table has following Fields.

MANDT

WERKS

LGORT

MATNR

SEQ_NUM

STDAT

STTIM

EDDAT

EDTIM

I need to send request to BAsis Team for creating Authorization Object but I dont know what to send them

Plz Help

Re: Table Insert Authorization for ZTABLE

Former Member — Fri, 11 Mar 2011 10:52:31 GMT

Hi,

Please find your solution from this address.

With regards,

Aahbha

Edited by: Thomas Zloch on Mar 11, 2011 1:47 PM

Re: Table Insert Authorization for ZTABLE

Karan_Chopra_ — Fri, 11 Mar 2011 11:25:02 GMT

I need to update table from my Program and not thru SM30 transaction.

Re: Table Insert Authorization for ZTABLE

sandip_sonar — Fri, 11 Mar 2011 11:27:29 GMT

Create One Screen which have to fields User name and Passoword. Create one z table for storing both these field

And Create one more screen to UPDATE and INSERT in the required Z table in program. you can set authorization only to

those users which you have maintaind in new z table.

S Sonar

Re: Table Insert Authorization for ZTABLE

Former Member — Fri, 11 Mar 2011 11:53:44 GMT

May be an approach would be have the WERKS fields in your selection screen and create a authority object which would check the WERKS and returns for a user whether they are authorized to edit the table for that werks.

For all the authorized WERKS you can call the table through the FM VIEW_MAINTENANCE_CALL specifying the filtering with the authorized WERKS.

That's one of the approach i can think of. You can more restrictions based on other fields as well. You need to provide this information about the fields on which you want to check authorizations. Also, you can specify what level of authorizations, for some users it can be display only and for some it can be Read/Write access to the table entries.

Don't forget to generate the table maintenance before doing all these.

Regards

Ranganath

Re: Table Insert Authorization for ZTABLE

Former Member — Fri, 11 Mar 2011 11:57:41 GMT

Hi,

I understand that you want to provide authorization through your report.

For that you can create a Authorization Object with Activity and User Name and call that Authorization Object in your program.

You can control insert/Update with the User Name.

Already a lot of threads are present in SDN regarding authorization Object, for reference you can search.

Thanks

Arbind

Re: Table Insert Authorization for ZTABLE

Former Member — Fri, 11 Mar 2011 12:30:20 GMT

I agere with Arbind,

create a Z authorization code from trx SU21and call it from your program

Re: Table Insert Authorization for ZTABLE

SuhaSaha — Fri, 11 Mar 2011 12:46:41 GMT

Hello Karan,

Are you creating a table maintenance generator for this particular custom table?

If yes, then i don't think you need to create an additional Auth. Obj. for this. You can make use of the existing obj. S_TABU_DIS.

For this you'll have to make create a new auth. group while defining the TMG & then in you program call the auth. object:

AUTHORITY-CHECK OBJECT 'S_TABU_DIS'
      ID 'ACTVT' FIELD '02' "Change
      ID 'DICBERCLS' FIELD 'ZAUTH'. "Custom Auth. Group

  IF sy-subrc = 0.
*  Add your logic
  ENDIF.

BR,

Suhas