SAP ABAP Class CL_DBMS_USER_HDB (DB User Administration for DB HANA)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-USR-ADM (Application Component) User and Authorization Management
     ⤷ SUSR_IDENTITY_DBMS (Package) Data Base Management System User Administration

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_DBMS_USER	Interface of Data Base User	20120904

Properties

Class	CL_DBMS_USER_HDB
Short Description	DB User Administration for DB HANA
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SUSR_IDENTITY_DBMS	Data Base Management System User Administration
Created	20120904	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_DBMS_USER_HDB has no forward declaration.

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_DBMS_USER	☐	☐	Interface of Data Base User	20120904

Friends

Class CL_DBMS_USER_HDB has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CO_DBMS	Constant	Private	☐	Type reference (TYPE)	DBCON_DBMS	'HDB'	Database system	20120904
2	MO_DBMS_CONNECT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20120913
3	MO_SQL_ADBC	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20120904
4	MT_DB_TECH_USERS	Instance attribute	Private	☐	Type reference (TYPE)	TY_T_DB_TECH_USER		technical Db users	20130227

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20120913
2	DOUBLEQUOTE	Static method	Private	Method		20121123
3	ESCAPE_DOUBLEQUOTE	Static method	Private	Method		20131021
4	GRANT_ROLE	Instance method	Private	Method	Grant DB role to DB user	20130207
5	HANDLE_SQL_EXCEPTION	Static method	Private	Method	Convert DBMS messages to T100 messages	20130124
6	MODIFY_ROLE_USER_ASSIGNMENT	Instance method	Private	Method	Change the roles user assignment	20130207
7	REVOKE_ROLE	Instance method	Private	Method	Revoke DB role from DB user	20130207

Events

Class CL_DBMS_USER_HDB has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TY_S_ROLE_SELECT_NAME	Private	See coding			20130207	BEGIN OF ty_s_role_select_name, role_name TYPE suid_dbms_role, END OF ty_s_role_select_name
2	TY_S_ROLE_SELECT_RESULT	Private	See coding			20130213	BEGIN OF ty_s_role_select_result, role_name TYPE suid_dbms_role, grantor TYPE if_dbms_user=>ty_db_user_name, END OF ty_s_role_select_result
3	TY_S_USER_SELECT_NAME	Private	See coding			20121004	BEGIN OF ty_s_user_select_name, user_name TYPE if_dbms_user=>ty_db_user_name, END OF ty_s_user_select_name
4	TY_S_USER_SELECT_RESULT	Private	See coding			20120914	BEGIN OF ty_s_user_select_result, user_name TYPE if_dbms_user=>ty_db_user_name, user_id TYPE n LENGTH 10, user_mode TYPE string, external_identity type c length 255, creator type if_dbms_user=>ty_db_user_name, user_deactivated TYPE c LENGTH 5, END OF ty_s_user_select_result
5	TY_T_DB_TECH_USER	Private	See coding			20130227	ty_t_db_tech_user TYPE STANDARD TABLE OF if_dbms_user~ty_db_user_name WITH DEFAULT KEY
6	TY_T_ROLE_SELECT_NAME	Private	See coding			20130207	ty_t_role_select_name TYPE STANDARD TABLE OF ty_s_role_select_name WITH DEFAULT KEY
7	TY_T_ROLE_SELECT_RESULT	Private	See coding			20130213	ty_t_role_select_result TYPE STANDARD TABLE OF ty_s_role_select_result WITH DEFAULT KEY
8	TY_T_USER_SELECT_NAME	Private	See coding			20121004	ty_t_user_select_name TYPE STANDARD TABLE OF ty_s_user_select_name WITH DEFAULT KEY
9	TY_T_USER_SELECT_RESULT	Private	See coding			20120914	ty_t_user_select_result TYPE STANDARD TABLE OF ty_s_user_select_result WITH DEFAULT KEY

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_DBMS_CONNECTION	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20120913

Method CONSTRUCTOR on class CL_DBMS_USER_HDB has no exception.

Method DOUBLEQUOTE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_VAL	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20121123
2	Returning	RV_OUT	Value transfer	☐	Type reference (TYPE)	STRING			20121123

Method DOUBLEQUOTE on class CL_DBMS_USER_HDB has no exception.

Method ESCAPE_DOUBLEQUOTE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_VAL	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20131021
2	Returning	RV_OUT	Value transfer	☐	Type reference (TYPE)	STRING			20131021

Method ESCAPE_DOUBLEQUOTE on class CL_DBMS_USER_HDB has no exception.

Method GRANT_ROLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MESSAGES	Call by reference	☐	Type reference (TYPE)	BAPIRETTAB		Table with BAPI Return Information	20130207
2	Exporting	EV_FAILED	Call by reference	☐	Type reference (TYPE)	BOOLE_D		X: role cannot be granted	20130207
3	Importing	IV_DB_USER_NAME	Call by reference	☐	Type reference (TYPE)	SUID_DBMS_USER		DBMS User	20130207
4	Importing	IV_ROLE_NAME	Call by reference	☐	Type reference (TYPE)	SUID_DBMS_ROLE		DB role	20130207

Method GRANT_ROLE on class CL_DBMS_USER_HDB has no exception.

Method HANDLE_SQL_EXCEPTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_MESSAGES	Call by reference	☐	Type reference (TYPE)	BAPIRETTAB		Table messages	20130124
2	Importing	IR_EXC_SQL	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20130124
3	Importing	IV_ROLE_NAME	Call by reference	☑	Type reference (TYPE)	SUID_DBMS_ROLE		DBMS Role	20130215

Method HANDLE_SQL_EXCEPTION on class CL_DBMS_USER_HDB has no exception.

Method MODIFY_ROLE_USER_ASSIGNMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MESSAGES	Call by reference	☐	Type reference (TYPE)	BAPIRETTAB		Table with BAPI Return Information	20130207
2	Exporting	EV_FAILED	Call by reference	☐	Type reference (TYPE)	BOOLE_D		X: user cannot be modified	20130207
3	Importing	IT_ROLE_NAMES	Call by reference	☐	Type reference (TYPE)	IF_DBMS_USER~TY_T_DB_ROLE_INFO		List of DB roles	20130207
4	Importing	IV_DB_USER_NAME	Call by reference	☐	Type reference (TYPE)	SUID_DBMS_USER		DBMS User	20130207

Method MODIFY_ROLE_USER_ASSIGNMENT on class CL_DBMS_USER_HDB has no exception.

Method REVOKE_ROLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MESSAGES	Call by reference	☐	Type reference (TYPE)	BAPIRETTAB		Table with BAPI Return Information	20130207
2	Exporting	EV_FAILED	Call by reference	☐	Type reference (TYPE)	BOOLE_D		X: role cannot be revoked	20130207
3	Importing	IV_DB_USER_NAME	Call by reference	☐	Type reference (TYPE)	SUID_DBMS_USER		DBMS User	20130207
4	Importing	IV_GRANTOR_NAME	Call by reference	☐	Type reference (TYPE)	SUID_DBMS_USER		DBMS User	20130227
5	Importing	IV_ROLE_NAME	Call by reference	☐	Type reference (TYPE)	SUID_DBMS_ROLE		DB role	20130207

Method REVOKE_ROLE on class CL_DBMS_USER_HDB has no exception.

History

Last changed by/on	SAP	20140121
SAP Release Created in	740