Oracle Internet File System Setup and Administration Guide Release 1.1 A81197-05 |
|
Using the Oracle iFS repository views, experienced database administrators can see the effects of changes they make to the Oracle iFS repository in a familiar format. This chapter provides information on the SQL views provided with Oracle iFS and an example of each. The following topics are included:
Repository views are created when Oracle iFS is installed. The Oracle iFS repository views are created when Oracle iFS is installed. The views are owned by the repository owner: ifssys. The Oracle iFS SQL read-only views are created with the Oracle iFS schema and are for informational purposes only. Grant the SELECT permission to users who need access to these views.
Note: The Oracle iFS views should be used exclusively by system administrators. The data in the views bypass all security; therefore, caution should be taken in granting users access to these views. |
The names of objects in the view may not be unique. Therefore, IDs are provided. Any column of type date
has two columns in the view, for example:
CREATE_DATE_GMT
--The standard Oracle8 date format, based on Greenwich Mean Time.
These eight repository views are provided out-of-the-box. Each view is described in a separate table which provides the name of the column, whether the column can be null, the type of column, and the length for each view.
ifs_versioned_documents
ifs_all_documents
ifs_folders
ifs_folder_items
ifs_users
ifs_groups
ifs_group_members
ifs_acls
This view shows a list of all documents which are versioned.
This view shows a list of all documents.
This view shows all folders and their attributes.
This view lists all folders and the top level items.
This view lists all users.
This view lists all groups.
This view lists groups and their direct members.
This view lists all ACLs in Oracle iFS.
This example uses ifs_versioned_documents to select attributes. To accomplish this, the following command is run:
SQL> select name, format, document_size, media, document_id, acl, owner from ifs_versioned_documents
The following table displays the output.
|
Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|