Are there any tables that I can get all Oracle supported system privileges and object privileges? I know there is a view called
all_sys_privs in Oracle. But I can't find more information about it.
Try this query for object privileges by object type.
The following takes into account privilege types that exist in table_privilege_map but not in the existing database objects.
You can look into sys.table_privilege_map (at-least 11g onwards, might exist before but I have no way to check) for a listing of possible object privileges, be warned not all apply to all object types.