How to make Direct SQL Read

[Former Member]

Hi Experts,

Do you have any ideas on how to access the database tables below? It is not in the SAP ABAP Dictionary.

SELECT * FROM DBA_ROLE_PRIVS

SELECT * FROM DBA_USERS

SELECT * FROM DBA_SYS_PRIVS

WHERE

PRIVILEGE='CREATE USER' OR

PRIVILEGE='BECOME USER' OR

PRIVILEGE='ALTER USER' OR

PRIVILEGE='DROP USER' OR

PRIVILEGE='CREATE ROLE' OR

PRIVILEGE='ALTER ANY ROLE' OR

PRIVILEGE='DROP ANY ROLE' OR

PRIVILEGE='GRANT ANY ROLE' OR

PRIVILEGE='CREATE PROFILE' OR

PRIVILEGE='ALTER PROFILE' OR

PRIVILEGE='DROP PROFILE' OR

PRIVILEGE='CREATE ANY TABLE' OR

PRIVILEGE='ALTER ANY TABLE' OR

PRIVILEGE='DROP ANY TABLE' OR

PRIVILEGE='INSERT ANY TABLE' OR

PRIVILEGE='UPDATE ANY TABLE' OR

PRIVILEGE='DELETE ANY TABLE' OR

PRIVILEGE='CREATE ANY PROCEDURE' OR

PRIVILEGE='ALTER ANY PROCEDURE' OR

PRIVILEGE='DROP ANY PROCEDURE' OR

PRIVILEGE='CREATE ANY TRIGGER' OR

PRIVILEGE='ALTER ANY TRIGGER' OR

PRIVILEGE='DROP ANY TRIGGER' OR

PRIVILEGE='CREATE TABLESPACE' OR

PRIVILEGE='ALTER TABLESPACE' OR

PRIVILEGE='DROP TABLESPACES' OR

PRIVILEGE='ALTER DATABASE' OR

PRIVILEGE='ALTER SYSTEM'

Thanks a lot!

[SuhaSaha]

Looks like you need ABAP DB Connectivity classes for this purpose. (e.g., CL_SQL* classes)

Check the demo program ADBC_DEMO.

BR,

Suhas

[Former Member]

Found a Solution not by SAP Access. Went to CMD of Windows and connected to ORACLE server through telnet, used *SQLPlus system to retrieve data.