Identify tables WITHOUT 'default' default view with 'empty' user in sys_ui_list

cynlink1
Tera Expert

‎11-22-2023 02:02 PM

I need help identifying tables without a default view for 'empty' user in sys_ui_list. I am unsure of how to write a script that returns negative search results. Any advice would be appreciated. Thanks!

0 Helpfuls
  • 198 Views
2 REPLIES 2

AshishKM
Kilo Patron
Kilo Patron

‎11-22-2023 02:13 PM

Hi @cynlink1 , 

Are you looking for list of table where User & View both are empty. 

AshishKMishra_0-1700691133401.png

-Thanks,

AshishKMishra


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
0 Helpfuls

cynlink1
Tera Expert
In response to AshishKM

‎11-22-2023 02:17 PM

Hi,

 

Thanks for the quick response. I need to cycle through all of the records in the sys_ui_list and identify tables that do not have a default view with an empty user. 

 

Thanks!

0 Helpfuls