SAP ABAP Class CL_DMCC_AUTH_REPL (basic functionality for replicating auth-data)

Hierarchy

☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-EUR (Application Component) European Monetary Union: Euro
     ⤷ CNV_DMC_CONTENT_REPL (Package) Data Mapping and Conversion: Content Replication

Properties

Class	CL_DMCC_AUTH_REPL
Short Description	basic functionality for replicating auth-data
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	CNV_DMC_CONTENT_REPL	Data Mapping and Conversion: Content Replication
Created	20130607	SAP
Last change	20141030
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_DMCC_AUTH_REPL has no forward declaration.

Interfaces

Class CL_DMCC_AUTH_REPL has no interface implemented.

Friends

Class CL_DMCC_AUTH_REPL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	LO_LOG_HANDLER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DMC_LOG_HANDLER		Log handler for MWB/DTL	20130619
2	LS_AUTH_STG	Instance attribute	Private	☐	Type reference (TYPE)	DMCC_AUTH_STG		Line of DMCC_AUTH_STG	20130610
3	LT_AUTH_MAP	Instance attribute	Private	☐	Type reference (TYPE)	DMCC_AUTH_MAP_TAB		itab of DMCC_AUTH_MAP	20130610
4	LT_AUTH_USER	Instance attribute	Private	☐	Type reference (TYPE)	DMCC_AUTH_USER_TAB		itab of DMCC_AUTH_USER	20130610
5	LV_DB_HOST	Instance attribute	Private	☐	Type reference (TYPE)	DMCC_DATABASE_HOST		DB hostname	20130620
6	LV_DB_NAME	Instance attribute	Private	☐	Type reference (TYPE)	DMCC_DATABASE_NAME		System SID of Database	20130620
7	LV_MT_ID	Instance attribute	Public	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20130611
8	LV_RFCDEST_SENDER	Instance attribute	Private	☐	Type reference (TYPE)	RFCDEST		Logical Destination (Specified in Function Call)	20130620

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20130610
2	EXECUTE_DDL_STATEMENT	Instance method	Private	Method	executes a supplied SQL-Statement	20130612
3	EXECUTE_GRANT	Instance method	Private	Method	executes the grant permissions	20130607
4	EXECUTE_GRANT_SINGLE_ROLE	Instance method	Private	Method	executes a Grant for a single role/	20130621
5	EXECUTE_REVOKE	Instance method	Private	Method	executes the revoke permissions	20130607
6	EXECUTE_REVOKE_SINGLE_ROLE	Instance method	Private	Method	executes a Grant for a single role/	20130621
7	EXECUTE_ROLE_MAPPING	Instance method	Public	Method	starts the rule mapping	20130611
8	EXECUTE_SQL_QUERY	Instance method	Private	Method	executes a DDL query	20130612
9	EXISTS_USER_IN_HDB	Instance method	Private	Method	checks whether user exists already in HANA or not	20130612
10	EXIST_ROLE_STRUCT_FOR_HDB_USER	Instance method	Private	Method	Check if user has at least 1 role or struct-priv assigned	20130725
11	GET_EMAIL_ADDRESS_FOR_UNAME	Instance method	Private	Method	supplies the email-address for a supplied uname	20130612
12	GET_HDB_USER	Instance method	Private	Method	retrieve hdb_user for mt_id and user_sap	20130611
13	GET_INITIAL_CONFIG	Instance method	Private	Method	loads initial values from db	20130610
14	SEND_EMAIL	Instance method	Private	Method	send information via an email	20130607

Events

Class CL_DMCC_AUTH_REPL has no event.

Types

Class CL_DMCC_AUTH_REPL has no local type.

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130620
2	Importing	IV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20130610
3	Importing	IV_RFCDEST_SENDER	Call by reference	☐	Type reference (TYPE)	RFCDEST		Logical Destination (Specified in Function Call)	20130620

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130611

Method EXECUTE_DDL_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130612
2	Importing	IV_STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING		SQL Statement as string	20130612

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20130612

Method EXECUTE_GRANT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130612
2	Importing	IV_AGR_NAME	Call by reference	☐	Type reference (TYPE)	AGR_USERS-AGR_NAME		Role Name	20130924
3	Importing	IV_USER_HDB	Call by reference	☐	Type reference (TYPE)	DMCC_AUTH_USER-USER_HDB		username in HANA-DB	20130612
4	Importing	IV_USER_SAP	Call by reference	☐	Type reference (TYPE)	AGR_USERS-UNAME		User Name in User Master Record	20130612

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130612

Method EXECUTE_GRANT_SINGLE_ROLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130621
2	Importing	IV_ROLE	Call by reference	☐	Type reference (TYPE)	AGR_USERS-AGR_NAME		Role Name	20130621
3	Importing	IV_STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING			20130621
4	Importing	IV_USER_HDB	Call by reference	☐	Type reference (TYPE)	DMCC_HDB_USERNAME		username in HANA-DB	20130621
5	Importing	IV_USER_SAP	Call by reference	☐	Type reference (TYPE)	XUBNAME		User Name in User Master Record	20130621

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130621

Method EXECUTE_REVOKE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130611
2	Importing	IV_AGR_NAME	Call by reference	☐	Type reference (TYPE)	AGR_NAME		Role Name	20130621
3	Importing	IV_MANDT	Call by reference	☐	Type reference (TYPE)	SYMANDT		R/3 System, client number from logon	20130620
4	Importing	IV_UNAME	Call by reference	☐	Type reference (TYPE)	AGR_USERS-UNAME		User Name in User Master Record	20130620
5	Importing	IV_USER_HDB	Call by reference	☐	Type reference (TYPE)	DMCC_AUTH_USER-USER_HDB		username in HANA-DB	20130611

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130612

Method EXECUTE_REVOKE_SINGLE_ROLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130621
2	Importing	IV_ROLE	Call by reference	☐	Type reference (TYPE)	AGR_USERS-AGR_NAME		Role Name	20130621
3	Importing	IV_STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING			20130621
4	Importing	IV_USER_HDB	Call by reference	☐	Type reference (TYPE)	DMCC_HDB_USERNAME		username in HANA-DB	20130621
5	Importing	IV_USER_SAP	Call by reference	☐	Type reference (TYPE)	XUBNAME		User Name in User Master Record	20130621

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130621

Method EXECUTE_ROLE_MAPPING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130611
2	Importing	IV_AGR_NAME	Call by reference	☐	Type reference (TYPE)	AGR_USERS-AGR_NAME		Role Name	20130611
3	Importing	IV_MANDT	Call by reference	☐	Type reference (TYPE)	SYMANDT		R/3 System, client number from logon	20130620
4	Importing	IV_OPERATION	Call by reference	☐	Type reference (TYPE)	CHAR1		Single-Character Flag	20130611
5	Importing	IV_TO_DAT	Call by reference	☐	Type reference (TYPE)	AGR_USERS-TO_DAT		Date of validity	20130611
6	Importing	IV_UNAME	Call by reference	☐	Type reference (TYPE)	AGR_USERS-UNAME		User Name in User Master Record	20130611

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130611

Method EXECUTE_SQL_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ER_RESULT	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET		Resulting Set of an SQL Query	20130612
2	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130612
3	Importing	IV_STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING			20130612

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20130612

Method EXISTS_USER_IN_HDB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130612
2	Importing	IV_USER_HDB	Call by reference	☐	Type reference (TYPE)	DMCC_HDB_USERNAME		username in HANA-DB	20130612

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130612

Method EXIST_ROLE_STRUCT_FOR_HDB_USER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130725
2	Importing	IV_USER_HDB	Call by reference	☐	Type reference (TYPE)	DMCC_HDB_USERNAME		username in HANA-DB	20130725
3	Returning	RV_STATUS	Value transfer	☐	Type reference (TYPE)	CHAR1		Single-Character Flag	20130725

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130725

Method GET_EMAIL_ADDRESS_FOR_UNAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_UNAME	Call by reference	☐	Type reference (TYPE)	AGR_USERS-UNAME		User Name in User Master Record	20130612
2	Returning	RV_MAIL_ADDRESS	Value transfer	☐	Type reference (TYPE)	AD_SMTPADR		E-Mail Address	20130612

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130612

Method GET_HDB_USER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_UNAME	Call by reference	☐	Type reference (TYPE)	AGR_USERS-UNAME		User Name	20130611
2	Returning	RV_USER_HDB	Value transfer	☐	Type reference (TYPE)	DMCC_AUTH_USER-USER_HDB		username in HANA-DB	20130611

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130611

Method GET_INITIAL_CONFIG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20130610

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130611

Method SEND_EMAIL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_MAIL_RECIPIENT	Call by reference	☐	Type reference (TYPE)	AD_SMTPADR		E-Mail Address	20130610
2	Importing	IV_PASSWORD	Call by reference	☐	Type reference (TYPE)	DBCON_PWD		Objcont and Objhead as Table Type	20130612
3	Importing	IV_SUBJECT	Call by reference	☐	Type reference (TYPE)	SO_OBJ_DES		Short description of contents	20130610

#	Exception	Resumable	Description	Created on
1	CX_DMCC_AUTH_REPL_ERR	☐	Exception class for CL_DMCC_AUTH_REPL	20130612

History

Last changed by/on	SAP	20141030
SAP Release Created in	2010_1_620