Access to GRC AC 5.3 Tables

[yudittzruya]

Hi All,

wanted to know how can we access the DB tables of the deferent components and where can we find a list of all the tables.

Thanks

Yudit

[Former Member]

Hi Jagat,

Before opening that URL, login to the product. Once logged in then type the URL and it will work.

Regards,

Alpesh

[Former Member]

HI ,

Why do you want to have access at the db level.Try searching in tables the db schema .......all would be virsa tables.<schemaid>.<table-name>.

[Former Member]

Dear Yudit,

You can access the tables from database and all the tables starts from VIRSA_AE*.

There is a another option to view the tables in display mode only. Kindly go to th following link and there you can run the 'SELECT' Quaries.

http://<Server>:<Port>/AE/opensql_test.jsp

This link will open a page where you can run your 'SELECT' statements.

Thanks,

Hemant

[Former Member]

Good Day Hemant,

I tried this but getting following error:-

"Application error occurred during the request procession.

Details: com.sap.engine.services.servlets_jsp.server.exceptions.WebIOException:

Error compiling [/opensql_test.jsp] of alias [AE] of J2EE application [sap.com/grc~aeear].

Exception id: [001E4F38A65E005F0000019600002C100004629D61B61582]"

Thanks and Regards,

Jagat

[Former Member]

Hi Yudit

What is your database ?. If it is oracle use

Go to Os level -> SQLplus -> connect / as sysdba

then execute the following query

select table_name from dba_tables where table_name LIKE 'VIRSA%' AND OWNER='SAPSR3DB';

If you are not comfortable with SQLplus you can ask the help of dba or basis.

This will list all the tables of GRC applications.

for checking the contents of any particular virsa table go to CCdebugger and do a select query.

[Former Member]

Hi Yudit ,

How you access the tables depends on which DB you are using.

Some of the table for access enforcer ( CUP) are as follows ;;

VIRSA_AE_*

Hope this helps. !!

Regards,

Shailesh