Database Reference
In-Depth Information
Table 9-1. Abbreviations Used in X$ Fixed Table Names (Continued)
Abbreviation
Presumed Meaning
KTU
Kernel Transaction Undo
KX
Kernel eXecution
KXS
Kernel eXecution Sql
Granting Access to X$ Tables and V$ Views
For users other than SYS, the role SELECT_CATALOG_ROLE is sufficient to access V$ views in SQL
statements and anonymous blocks. Since roles are disabled inside stored PL/SQL routines such as
packages, users who require access to V$ or GV$ views from PL/SQL must be granted SELECT on
the corresponding V_$ or GV_$ view directly, rather than indirectly through a role. Another
option is to grant the system privilege SELECT ANY DICTIONARY . The latter option should be used
with caution, since it grants access to unencrypted passwords in SYS.LINK$ in Oracle9 i . If secu-
rity is a concern, you might not even want to give access to password hashes in DBA_USERS with
SELECT_CATALOG_ROLE , since an intruder might try to crack them.
Contrary to V$ fixed views and corresponding V_$ views, there are no X_$ views on X$ fixed
tables. Hence there is no quick way to grant access to X$ tables to users other than SYS. The
preferred way to implement this access is to mimic the approach taken with V$ views, by creating
true views on X$ tables owned by SYS and granting access to these. Following the naming
conventions, these views might be given the prefix X_$. Except for the prefix, this is precisely
the approach taken in the implementation of Statspack. The Statspack installation script creates
three such views. Their names and purpose are summarized in Table 9-2. Access to these views
is granted to user PERFSTAT only, but grants to other users are in order.
Table 9-2. Statspack Views on X$ Fixed Tables
Public Synonym
View
X$ Base Table
Associated
V$ Views
STATS$X$KSPPI
STATS$X_$KSPPI
X$KSPPI (Parameter
names and descriptions)
V$PARAMETER
V$PARAMETER2
V$SGA_CURRENT_RESIZE_OPS
V$SGA_RESIZE_OPS
V$SYSTEM_PARAMETER2
V$SYSTEM_PARAMETER
STATS$X$KSPPSV
STATS$X_$KSPPSV
X$KSPPSV (Parameter
values at system level)
V$SYSTEM_PARAMETER
V$SYSTEM_PARAMETER2
STATS$X$KCBFWAIT
STATS$X_$KCBFWAIT
X$KCBFWAIT (Wait time
and number of waits at
data file level)
n/a
 
Search WWH ::




Custom Search