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
Obtains the current SCN number
AUTHID
DEFINER
Dependencies
STANDARD (only)
Documented
No
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/prvthtxn.plb
GET_CURRENT_SCN
Returns the current System Change Number
dbms_transaction_internal_sys.get_current_scn(
base_ub1 IN BINARY_INTEGER,
wrap_ub2 IN BINARY_INTEGER)
RETURN NUMBER;
SELECT dbms_flashback.get_system_change_number,
dbms_transaction_internal_sys.get_current_scn,
current_scn
FROM v$database;
