November 25, 2014 Data Mining: Concepts and
Techniques 1
Data Warehouse Security
•Responsibility and Confidentiality : The Data Warehouse contains
confidential and sensitive University data. In order to use its data, you
must have proper authorization. Your authorization means that you have
the authority to use the data and the responsibility to share stewardship
of the data with the other users of the collection.
•Once authorized, you can access the data that you need to do your job.
All authorized users are cautioned, however, that they are entrusted to
use the data they retrieve from the Warehouse with care. Confidential
data should not be released to others except for those with a "legitimate
need to know."
•Please remember that you should never share Business Objects queries
with other users with the data intact -- send the query without the data.
More information about sending and saving Business Objects documents.
•Querying Data with Security Restrictions : If you execute a query
requesting data that you are not authorized to access, you will get results
which may be incomplete because they are missing the data you are not
allowed to access.
•If your authorization is limited to a specific set of data, be sure when
querying the data that your record selection conditions include your
security restrictions. For example, if you are authorized to access just
data for a particular department, one of your record selection conditions
should state something like "If Organization= 'My Organization'," where
My Organization is the code of your department. This will document why
the query gets the results it does, and will also help your query run faster.
