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
APIs for building and managing a File Group repository
dbms_file_group.add_file(
file_group_name IN VARCHAR2,
file_name IN VARCHAR2,
file_type IN VARCHAR2 DEFAULT NULL,
file_directory IN VARCHAR2 DEFAULT NULL,
version_name IN VARCHAR2 DEFAULT NULL,
comments IN VARCHAR2 DEFAULT NULL);
dbms_file_group.alter_file(
file_group_name IN VARCHAR2,
file_name IN VARCHAR2,
version_name IN VARCHAR2 DEFAULT NULL,
new_file_name IN VARCHAR2 DEFAULT NULL,
new_file_directory IN VARCHAR2 DEFAULT NULL,
new_file_type IN VARCHAR2 DEFAULT NULL,
remove_file_type IN VARCHAR2 DEFAULT 'N',
new_comments IN VARCHAR2 DEFAULT NULL,
remove_comments IN VARCHAR2 DEFAULT 'N');
dbms_file_group.alter_file_group(
file_group_name IN VARCHAR2,
keep_files IN VARCHAR2 DEFAULT NULL,
min_versions IN NUMBER DEFAULT NULL,
max_versions IN NUMBER DEFAULT NULL,
retention_days IN NUMBER DEFAULT NULL,
new_default_directory IN VARCHAR2 DEFAULT NULL,
remove_default_directory IN VARCHAR2 DEFAULT 'N',
new_comments IN VARCHAR2 DEFAULT NULL,
remove_comments IN VARCHAR2 DEFAULT 'N');
dbms_file_group.alter_version(
file_group_name IN VARCHAR2,
version_name IN VARCHAR2 DEFAULT NULL,
new_version_name IN VARCHAR2 DEFAULT NULL,
remove_version_name IN VARCHAR2 DEFAULT 'N',
new_default_directory IN VARCHAR2 DEFAULT NULL,
remove_default_directory IN VARCHAR2 DEFAULT 'N',
new_comments IN VARCHAR2 DEFAULT NULL,
remove_comments IN VARCHAR2 DEFAULT 'N');
BEGIN
dbms_file_group.alter_version(
file_group_name => 'sh.grp_rptrepos',
version_name => 'salesforce_v3',
new_version_name => 'salesforce_v0',
new_comments => 'Sales Force Tablespace Version 0 (was 3)');
END;
/
dbms_file_group.create_file_group(
file_group_name IN VARCHAR2,
keep_files IN VARCHAR2 DEFAULT 'Y',
min_versions IN NUMBER DEFAULT 2,
max_versions IN NUMBER DEFAULT DBMS_FILE_GROUP.INFINITE,
retention_days IN NUMBER DEFAULT DBMS_FILE_GROUP.INFINITE,
default_directory IN VARCHAR2 DEFAULT NULL,
comments IN VARCHAR2 DEFAULT NULL);
dbms_file_group.create_version(
file_group_name IN VARCHAR2,
version_name IN VARCHAR2 DEFAULT NULL,
default_directory IN VARCHAR2 DEFAULT NULL,
comments IN VARCHAR2 DEFAULT NULL);
TBD
Overload 2
dbms_file_group.create_version(
file_group_name IN VARCHAR2,
version_name IN VARCHAR2 DEFAULT NULL,
default_directory IN VARCHAR2 DEFAULT NULL,
comments IN VARCHAR2 DEFAULT NULL,
version_out OUT VARCHAR2);
Grants object privileges on a file group to a user
dbms_file_group.grant_object_privilege(
object_name IN VARCHAR2,
privilege IN BINARY_INTEGER,
grantee IN VARCHAR2,
grant_option IN BOOLEAN DEFAULT FALSE);
dbms_file_group.remove_file(
file_group_name IN VARCHAR2,
file_name IN VARCHAR2,
version_name IN VARCHAR2 DEFAULT NULL,
keep_file IN VARCHAR2 DEFAULT NULL);