I'm experimenting with granting privileges to roles. I'm getting confused about some things. Firstly, as stated in my subject for this post, why isn't the 'PUBLIC' role listed as such when performing the query: SELECT * FROM DBA_ROLES ORDER BY 1;
Is it one of those things you just kinda have to remember? I can see in other queries that 'PUBLIC' is shown as the GRANTEE. For instance, when performing this query: SELECT * FROM USER_TAB_PRIVS; I can see 'PUBLIC' as the GRANTEE many many times.
Does the Oracle Database in general (I'm using XE 18.4.0.0.0 I believe) restrict the creation of the 'PUBLIC' role by an end-user as it might for restricting the creation of tables using keywords? I'm wondering if I tried creating the role myself in the past and I'm getting my user created role of 'PUBLIC' confused with the real one.