Hello,
I am using the Always Free Autonomous and it struck me as strange that it is not possible to use built in Domains. In my opinion these domains should be granted to Public, otherwise.. what's the point?
Maybe @martinbach-oracle can take this up?
The admin-user can't grant them (of course).
SQL> select banner_full
2* from v$version;
BANNER_FULL
_______________________________________________________________________________________________________
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.7.0.25.03
SQL>
SQL>
SQL> select owner
2 ,name
3 ,builtin
4 from ALL_DOMAINS
5 where owner = 'SYS'
6* and name = 'EMAIL_D';
OWNER NAME BUILTIN
________ __________ __________
SYS EMAIL_D true
SQL>
SQL>
SQL> create table t (
2 e sys.email_d
3* );
Error starting at line : 1 in command -
create table t (
e sys.email_d
)
Error report -
ORA-01031: insufficient privileges
https://docs.oracle.com/error-help/db/ora-01031/01031. 00000 - "insufficient privileges"
*Document: YES
*Cause: A database operation was attempted without the required
privilege(s).
*Action: Ask your database administrator or security administrator to grant
you the required privilege(s).