Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
SELECT object_type
FROM dba_objects
WHERE owner = 'SH'
AND object_name = 'CUSTOMERS_DIM';
OBJECT_TYPE
--------------------
DIMENSION
exec dbms_sumvdm.verify_dimension('CUSTOMERS_DIM', 'SH');
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SUMVDM", line 962
ORA-06512: at "SYS.DBMS_SUMVDM", line 302
ORA-06512: at line 1
-- given that this is undocumented it may well be me but I can't say I'm impressed. And lest you think I was looking for the table not the dimension name:
SQL> exec dbms_sumvdm.verify_dimension('CUSTOMERS', 'SH');
*
ERROR at line 1:
ORA-30478: Specified dimension does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_SUMVDM", line 505
ORA-06512: at line 1
-- so the exception message appear to be internally inconsistent.