(Glue-2002) Custom Glue Authorizations

Owned by SNP
Jul 04, 2019
2 min read

Glue uses the following authorization objects:

  • /DVD/GLUE1 – access to SAP tables
  • /DVD/GLUE2 – Glue object access (currently implemented only for extractors and TMS)
  • /DVD/GLUES – access to Storage tables
  • S_TABU_DIS – standard SAP authorization object for data access
  • S_TABU_NAM - standard SAP authorization object for table access
  • S_RS_ODSO – standard SAP authorization object for DSO access
  • S_RS_ICUBE – standard SAP authorization object for InfoCube access

Glue actions

Actions available in Glue authorization objects are:

    • CRE_GLUE11 → Create table in Glue11
    • DIS_GLUE11 → Display table in Glue11
    • DIS_GLUE16 → Display storage table data in Glue16
    • MAN_GLUE14 → Manage table in Glue14
    • DIS_EXT → Display extractor
    • MAN_EXT → Create and manage extractor
    • RUN_EXT → Run extraction
    • MAN_BPL → Create, manage and execute business objects (not supported yet)
    • CRE_TMS → Create Glue transport
    • IMP_TMS → Import Glue transport

Object /DVD/GLUE1

Fields:

  • TABNAME - SAP table name
  • GLUEACTION - Glue action
  • DLVUNIT - Software component

Usage:

  • Importing fields from SAP table into Glue Data Dictionary
  • Display, create, change or manage an extractor with an SAP table
  • Extraction from or into an SAP table

You can also use this authorization object to restrict access to DSO or InfoCube data by restricting access to their Active data table and Fact table.

Object /DVD/GLUE2

This object currently supports only extractor and TMS actions.

Fields:

  • GL_OBJ_NM - Glue object name
  • GL_OBJ_TP - Glue object type
  • DEVCLASS - SAP development class (nowadays known as “package”)
  • GLUEACTION - Glue action

Usage:

  • Manage Extractor (Create, Change, Manage)
  • Display Extractor
  • Create Variant (authorized with an extractor name and a type extractor)
  • Run Variant (authorized with an extractor name and a type extractor)
  • Create Glue transport
  • Import Glue transport

Object /DVD/GLUES

Fields:

  • STORAGEID - Storage ID

  • TABNAME - Storage table name

    We recommend following a strict naming convention for tables on an external storage so that tables are grouped based on their data, functional area or source system. In addition, please ensure that tables on an external storage don't have the same table name as on the SAP system. This is important for avoiding any kind of misunderstanding or mix up.

  • DEVCLASS - SAP development class (nowadays known as “package”)
  • GLUEACTION - Glue action

Usage:

  • Display a Glue table
  • Create a Glue table
  • Change a Glue table
  • Manage a table in /DVD/GL14
  • Display data in /DVD/GL16
  • Display, create, change or manage an extractor with a Glue table
  • Extraction from or into a Glue table

Object S_TABU_DIS

We implemented also the standard SAP authorization object S_TABU_DIS for data access. It can be used together with /DVD/GLUE1 or as its replacement.

Fields:

  • DICBERCLS - Table Authorization Group
  • ACTVT - Activity

Usage:

  • Import fields from SAP table
  • Create, change or manage an extractor with an SAP table
  • Extraction from or into an SAP table

Object  S_TABU_NAM

Standard SAP authorization object for table access. When the check on object S_TABU_DIS fails, then authorization against S_TABU_NAM is performed

Fields:

  • ACTVT - Activity
  • TABLE - Table name

Usage:

  • Same as S_TABU_DIS

Object S_RS_ODSO

The standard SAP authorization object S_RS_ODSO can be used to restrict access to DSO data (also you can perform this by restricting access to its Active data table using the object /DVD/GLUE1).

Fields:

  • ACTVT - Activity
  • RSINFOAREA - InfoArea
  • RSODSOBJ - DataStore object
  • RSODSPART - Subobject for ODS object

Usage:

  • Manage extractor of type "Standard DSO to Storage"
  • Extraction from DataStore object into a Glue table

Object S_RS_ICUBE

The standard SAP authorization object S_RS_ICUBE can be used to restrict access to InfoCube data (also you can perform this by restricting access to its Fact table using the object /DVD/GLUE1).

Fields:

  • ACTVT - Activity
  • RSINFOAREA - InfoArea
  • RSINFOCUBE - InfoCube
  • RSICUBEOBJ - InfoCube Subobject

Usage:

  • Manage extractor of the type "InfoCube to Storage"
  • Extraction from InfoCube into a Glue table