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.
Purpose
Given an object_id returns the object's schema name. Why anyone thought they needed a stand-alone PL/SQL package for this eludes me
AUTHID
DEFINER
Dependencies
DBMS_FILE_GROUP_EXP
OBJ$
USER$
DBMS_STANDARD
Documented
No
First Available
Unknown
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/prvthfie.plb
OBJECT_OWNER
Given an object_id returns the object's schema name
dbms_file_group_exp_internal(obj_id IN NUMBER) RETURN VARCHAR2;
SELECT object_id
FROM dba_objects
WHERE object_name = 'DBMS_FILE_GROUP_EXP_INTERNAL';
SELECT dbms_file_group_exp_internal.object_owner(14026)
FROM dual;