I'm trying to determine if - by default - select_catalog_role should have these privileges... based on the oracle documentation it states "select only" but, in reviewing our database I can see the following:
| GRANTEE | OWNER | TABLE_NAME | GRANTOR | PRIVILEGE | GRANTABLE | HIERARCHY |
| SELECT_CATALOG_ROLE | SYS | DBMS_RCVMAN | SYS | EXECUTE | NO | NO |
| SELECT_CATALOG_ROLE | SYS | DBMS_CDC_UTILITY | SYS | EXECUTE | NO | NO |
| SELECT_CATALOG_ROLE | SYS | DBA_AWS | SYS | DELETE | NO | NO |
| SELECT_CATALOG_ROLE | SYS | DBA_AWS | SYS | INSERT | NO | NO |
| SELECT_CATALOG_ROLE | SYS | DBA_AWS | SYS | UPDATE | NO | NO |
| SELECT_CATALOG_ROLE | SYS | DBA_AW_PS | SYS | DELETE | NO | NO |
| SELECT_CATALOG_ROLE | SYS | DBA_AW_PS | SYS | INSERT | NO | NO |
| SELECT_CATALOG_ROLE | SYS | DBA_AW_PS | SYS | UPDATE | NO | NO |
| SELECT_CATALOG_ROLE | SYS | KU$_MONITOR_T | SYS | EXECUTE | NO | NO |
So - does select catalog need these by default? Or - would someone had to have granted these specifically to select catalog role?
Any help is appreciated!