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

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.
Answers
-
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
0 -
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.
0 -
@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:
0 -
Check This:
0