In Oracle Data Warehouse databases, these functions will be present in package WH_TC_SECURITY:

•WH_TC_SECURITY.CHECK_USER_ACCESS_ACCOUNT

•WH_TC_SECURITY.CHECK_USER_ACCESS_APPOINTMENT

•WH_TC_SECURITY.CHECK_USER_ACCESS_CONTACT

•WH_TC_SECURITY.CHECK_USER_ACCESS_DOCUMENT

•WH_TC_SECURITY.CHECK_USER_ACCESS_EXPENSE

•WH_TC_SECURITY.CHECK_USER_ACCESS_HISTORY

•WH_TC_SECURITY.CHECK_USER_ACCESS_INVOICE

•WH_TC_SECURITY.CHECK_USER_ACCESS_INVOLVED

•WH_TC_SECURITY.CHECK_USER_ACCESS_LINEITEM

•WH_TC_SECURITY.CHECK_USER_ACCESS_MILESTONE

•WH_TC_SECURITY.CHECK_USER_ACCESS_PROJECT

•WH_TC_SECURITY.CHECK_USER_ACCESS_TASK

In SQL Server, the functions are:

•WH_CHECK_USER_ACCESS_ACCOUNT

•WH_CHECK_USER_ACCESS_APPOINTMENT

•WH_CHECK_USER_ACCESS_CONTACT

•WH_CHECK_USER_ACCESS_DOCUMENT

•WH_CHECK_USER_ACCESS_EXPENSE

•WH_CHECK_USER_ACCESS_HISTORY

•WH_CHECK_USER_ACCESS_INVOICE

•WH_CHECK_USER_ACCESS_INVOLVED

•WH_CHECK_USER_ACCESS_LINEITEM

•WH_CHECK_USER_ACCESS_MILESTONE

•WH_CHECK_USER_ACCESS_PROJECT

•WH_CHECK_USER_ACCESS_TASK

Two additional functions, WH_USER_ALLOWED and WH_USER_DENIED, are for internal use and should not be called by your reporting tools.

Note: All custom objects' rights are determined by the WH_TC_SECURITY.CHECK_USER_ACCESS_PROJECT function (Oracle) or WH_CHECK_USER_ACCESS_PROJECT function (SQL Server), regardless of the actual object type.

See System Table Definitions for details about the structure of the tables that implement this security feature.