viernes, 9 de julio de 2010

Oracle Tablas del Sistema (parte II / II)

Como podéis observar todas las opciones, configuraciones de oracle están en tablas así que para cambiar alguna configuración nos vale con modificar los registros.

/*
Database compatible parameter set via init.ora
*/
select *
from DATABASE_COMPATIBLE_LEVEL

/*
All database links in the database
*/ 
select *
from DBA_DB_LINKS
 
/*
 Current errors on all stored objects in the database
*/ 
select *
from DBA_ERRORS

/*
All objects in the database
*/
select *
from DBA_OBJECTS

/*
All Roles which exist in the database
*/ 
select *
from DBA_ROLES
 
/*
 Roles granted to users and roles
*/ 
select *
from DBA_ROLE_PRIVS

/*
Source of all stored objects in the database
*/
select *
from DBA_SOURCE
 
/*
Description of all tablespaces
*/
select *
from DBA_TABLESPACES

/*
 All grants on objects in the database
*/ 
select *
from DBA_TAB_PRIVS

/*
All triggers in the database
*/
select *
from DBA_TRIGGERS

/*
Tablespace quotas for all users
*/ 
select *
from DBA_TS_QUOTAS
 
/*
Information about all users of the database
*/
select *
from DBA_USERS
 
/*
Description of all views in the database
*/
select *
from DBA_VIEWS
 
/*
Description of data dictionary tables and views
*/ 
select *
from DICTIONARY

/*
Description of columns in data dictionary tables and views
*/ 
select *
from DICT_COLUMNS 

/*
 global database name
*/
select *
from GLOBAL_NAME

/*
Permanent NLS parameters of the database
*/
select *
from NLS_DATABASE_PARAMETERS

/*
NLS parameters of the instance
*/ 
select *
from NLS_INSTANCE_PARAMETERS 

/*
 NLS parameters of the user session
*/
select *
from NLS_SESSION_PARAMETERS

/*
 version and status information for component products
*/
select *
from PRODUCT_COMPONENT_VERSION

/*
 Table privileges granted to roles
*/
select *
from ROLE_TAB_PRIVS

/*
 Privileges which the user currently has set
*/
select *
from SESSION_PRIVS

/*
 Roles which the user currently has enabled.
*/
select *
from SESSION_ROLES

/*
 Description table for privilege type codes. Maps privilege type numbers to type names
*/
select *
from SYSTEM_PRIVILEGE_MAP

/*
 Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
*/
select *
from TABLE_PRIVILEGES

/*
 Description table for privilege (auditing option) type codes. Maps privilege
*/
select *
from TABLE_PRIVILEGE_MAP