Search Results bsc_user_tab_access




Overview
Explore in AI Chat

Overview

The BSC_USER_TAB_ACCESS table is a core security and configuration object within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It functions as a junction table that defines the relationship between user responsibilities and specific application tabs. Its primary role is to enforce tab-level permissions, controlling which navigation tabs within the Balanced Scorecard interface are accessible to users assigned a given responsibility. This granular security mechanism ensures users only see the functionality relevant to their defined role, adhering to the principle of least privilege within the application's security model.

Key Information Stored

The table's structure is concise, centered on the two foreign key columns that form its composite primary key. The RESPONSIBILITY_ID column stores a unique identifier that links to a specific responsibility defined in the BSC_RESPONSIBILITY table. The TAB_ID column stores a unique identifier that links to a specific application tab defined in the BSC_TABS_B table. The existence of a record in this table for a given RESPONSIBILITY_ID and TAB_ID pair explicitly grants access to that tab for users operating under that responsibility. The absence of a record implicitly denies access.

Common Use Cases and Queries

A primary use case is auditing and reporting on tab-level security assignments. System administrators may query this table to verify or modify the tabs available to a specific responsibility. Common SQL patterns include listing all tabs accessible to a responsibility or identifying which responsibilities have access to a particular tab. For example, to find all tab IDs granted to a specific responsibility, one would query: SELECT tab_id FROM bsc_user_tab_access WHERE responsibility_id = <RESP_ID>;. Conversely, to audit all responsibilities with access to a critical tab, the query would be: SELECT responsibility_id FROM bsc_user_tab_access WHERE tab_id = <TAB_ID>;. These queries are foundational for security reviews and access provisioning workflows within the BSC module.

Related Objects

The BSC_USER_TAB_ACCESS table maintains documented foreign key relationships with two primary master tables, as per the provided metadata:

  • BSC_RESPONSIBILITY: The table is referenced via the column BSC_USER_TAB_ACCESS.RESPONSIBILITY_ID. This relationship ties a tab permission record to a specific application responsibility.
  • BSC_TABS_B: The table is referenced via the column BSC_USER_TAB_ACCESS.TAB_ID. This relationship defines which specific application navigation tab the permission record governs.

The table's primary key constraint, BSC_USER_TAB_ACCESS_PK, is defined on the combination of (RESPONSIBILITY_ID, TAB_ID), ensuring a unique and non-nullable relationship between these two entities.