I see a table in ALL_TAB_COLUMNS, but when I try to query to table it says it doesn't exist.

drudd

So I was looking for a table and I could see it in the ALL_TAB_COLUMNS using this query:

SELECT DISTINCT
TABLE_NAME
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'ase_app_role_role_mbr'

However when I try to query the table

SELECT

*

FROM ase_app_role_role_mbr

I get an error:

ORA-00942: table or view does not exist

This is my first time seeing something like this and I would appreciate any advice on how to query the table.

Riyaz Ali-Oracle

Please review the below link as it might be helpful:

Per_user_roles or ase_user_role_mbr to be used for Reporting ? — Cloud Customer Connect

ASE table reference — Cloud Customer Connect

drudd

Riyaz Ali-Oracle

May 7, 2025

Please review the below link as it might be helpful:

Per_user_roles or ase_user_role_mbr to be used for Reporting ? — Cloud Customer Connect

ASE table reference — Cloud Customer Connect

I've seen that, but I really don't understand why. I need to be able to associate roles to their inherited roles and this looks like the only table that has that information. I've tried to pull the information from an analysis using knowledge areas, but it takes forever to load as a data source.

Doesn't make much sense to not provide this information in a BIP report.

Riyaz Ali-Oracle

@drudd,

ASE* tables should NOT be used for any kind of reporting (BIP etc.).

Security console features are primarily stored in ASE_* tables and these are not available to customers from 20B onwards.

ASE* tables are for internal processing, and tables related to ASE_* should NOT be used for reporting.

Customers should not be directly querying any ASE tables.  

Please check the below links for more details:

Database Reference

User's Guide

ASE table reference

Riyaz Ali-Oracle

Check This:

User Role Membership Report SQL Query / Tables