How to make Direct SQL Read

Former Member — Tue, 31 Aug 2010 04:33:29 GMT

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!

Re: How to make Direct SQL Read

SuhaSaha — Tue, 31 Aug 2010 04:53:00 GMT

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

Check the demo program ADBC_DEMO.

BR,

Suhas

Re: How to make Direct SQL Read

Former Member — Fri, 03 Sep 2010 01:35:07 GMT

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.

topic Re: How to make Direct SQL Read in Application Development and Automation Discussions

How to make Direct SQL Read

Re: How to make Direct SQL Read

Re: How to make Direct SQL Read