General Roles and System privileges assigned to DBAs in Oracle Projects

General Roles and System privileges assigned to DBA.
--------------------------------------------------------------------------
Roles
=============
GRANTED_ROLE
DATAPUMP_IMP_FULL_DATABASE
SCHEDULER_ADMIN
OLAP_DBA
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
OLAP_XS_ADMIN
SELECT_CATALOG_ROLE
EXP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
JAVA_DEPLOY
DATAPUMP_EXP_FULL_DATABASE
JAVA_ADMIN
XDB_SET_INVOKER
IMP_FULL_DATABASE
XDBADMIN








-----------------------------------------------------------------


SYS_PRIVS
===================
PRIVILEGE
DROP ANY CUBE BUILD PROCESS
CREATE CUBE
ALTER ANY CUBE DIMENSION
ALTER ANY MINING MODEL
DROP ANY MINING MODEL
DROP ANY EDITION
CHANGE NOTIFICATION
ADMINISTER ANY SQL TUNING SET
ALTER ANY SQL PROFILE
CREATE RULE
EXPORT FULL DATABASE
EXECUTE ANY EVALUATION CONTEXT
DEQUEUE ANY QUEUE
DROP ANY INDEXTYPE
ALTER ANY INDEXTYPE
EXECUTE ANY LIBRARY
CREATE ANY LIBRARY
CREATE ANY DIRECTORY
ALTER PROFILE
EXECUTE ANY PROCEDURE
CREATE ROLE
SELECT ANY SEQUENCE
DROP ANY INDEX
UPDATE ANY TABLE
INSERT ANY TABLE
SELECT ANY TABLE
DROP ROLLBACK SEGMENT
BECOME USER
DROP TABLESPACE
ALTER SESSION
CREATE SESSION
DROP ANY MEASURE FOLDER
SELECT ANY CUBE
ALTER ANY CUBE
CREATE ANY ASSEMBLY
ALTER ANY EDITION
ANALYZE ANY DICTIONARY
ALTER ANY RULE SET
CREATE RULE SET
DEBUG ANY PROCEDURE
CREATE DIMENSION
ALTER ANY LIBRARY
UNDER ANY TYPE
DROP ANY MATERIALIZED VIEW
DROP ANY TRIGGER
ALTER ANY PROCEDURE
FORCE ANY TRANSACTION
ALTER DATABASE
DELETE ANY TABLE
ALTER ROLLBACK SEGMENT
UPDATE ANY CUBE DIMENSION
CREATE ANY CUBE BUILD PROCESS
CREATE CUBE DIMENSION
ALTER ANY ASSEMBLY
CREATE ASSEMBLY
CREATE ANY EDITION
EXECUTE ANY PROGRAM
EXECUTE ANY RULE
IMPORT FULL DATABASE
EXECUTE ANY RULE SET
CREATE ANY RULE SET
FLASHBACK ANY TABLE
RESUMABLE
ADMINISTER DATABASE TRIGGER
CREATE ANY OUTLINE
ALTER ANY DIMENSION
CREATE ANY DIMENSION
EXECUTE ANY OPERATOR
CREATE TYPE
CREATE TRIGGER
GRANT ANY ROLE
DROP ANY VIEW
CREATE VIEW
LOCK ANY TABLE
ALTER USER
CREATE USER
ALTER TABLESPACE
CREATE TABLESPACE
RESTRICTED SESSION
UPDATE ANY CUBE BUILD PROCESS
DROP ANY CUBE
INSERT ANY CUBE DIMENSION
CREATE MINING MODEL
CREATE ANY JOB
CREATE JOB
CREATE ANY RULE
DROP ANY EVALUATION CONTEXT
CREATE ANY EVALUATION CONTEXT
CREATE EVALUATION CONTEXT
GRANT ANY OBJECT PRIVILEGE
SELECT ANY DICTIONARY
DROP ANY DIMENSION
UNDER ANY TABLE
CREATE INDEXTYPE
CREATE ANY OPERATOR
DROP ANY LIBRARY
ANALYZE ANY
ALTER ANY ROLE
CREATE ANY SEQUENCE
CREATE ANY INDEX
CREATE ANY TABLE
DELETE ANY MEASURE FOLDER
CREATE ANY MEASURE FOLDER
SELECT ANY MINING MODEL
CREATE ANY MINING MODEL
MANAGE FILE GROUP
MANAGE SCHEDULER
ADMINISTER RESOURCE MANAGER
ALTER ANY OUTLINE
DROP ANY CONTEXT
EXECUTE ANY INDEXTYPE
UNDER ANY VIEW
DROP ANY TYPE
ALTER ANY TYPE
ALTER ANY MATERIALIZED VIEW
CREATE PROFILE
DROP PUBLIC DATABASE LINK
ALTER ANY INDEX
CREATE CLUSTER
COMMENT ANY TABLE
DROP ANY TABLE
CREATE ROLLBACK SEGMENT
UNLIMITED TABLESPACE
AUDIT SYSTEM
ALTER SYSTEM
SELECT ANY CUBE DIMENSION
DELETE ANY CUBE DIMENSION
CREATE ANY CUBE DIMENSION
COMMENT ANY MINING MODEL
EXECUTE ASSEMBLY
EXECUTE ANY ASSEMBLY
MANAGE ANY FILE GROUP
EXECUTE ANY CLASS
DROP ANY RULE SET
DEBUG CONNECT SESSION
ON COMMIT REFRESH
ENQUEUE ANY QUEUE
CREATE ANY INDEXTYPE
ALTER ANY OPERATOR
CREATE ANY TYPE
DROP ANY DIRECTORY
ALTER RESOURCE COST
CREATE ANY PROCEDURE
CREATE PROCEDURE
FORCE TRANSACTION
ALTER ANY SEQUENCE
CREATE SEQUENCE
CREATE ANY VIEW
DROP PUBLIC SYNONYM
DROP ANY SYNONYM
CREATE ANY CLUSTER
BACKUP ANY TABLE
CREATE TABLE
ADMINISTER SQL MANAGEMENT OBJECT
INSERT ANY MEASURE FOLDER
UPDATE ANY CUBE
ADMINISTER SQL TUNING SET
MERGE ANY VIEW
DROP ANY OUTLINE
CREATE OPERATOR
CREATE LIBRARY
GRANT ANY PRIVILEGE
DROP PROFILE
ALTER ANY TRIGGER
CREATE ANY TRIGGER
DROP ANY PROCEDURE
AUDIT ANY
DROP ANY ROLE
DROP ANY SEQUENCE
CREATE PUBLIC SYNONYM
CREATE SYNONYM
DROP ANY CLUSTER
ALTER ANY TABLE
FLASHBACK ARCHIVE ADMINISTER
CREATE CUBE BUILD PROCESS
CREATE MEASURE FOLDER
CREATE ANY CUBE
DROP ANY CUBE DIMENSION
DROP ANY ASSEMBLY
CREATE EXTERNAL JOB
READ ANY FILE GROUP
CREATE ANY SQL PROFILE
DROP ANY SQL PROFILE
SELECT ANY TRANSACTION
ADVISOR
DROP ANY RULE
ALTER ANY RULE
ALTER ANY EVALUATION CONTEXT
CREATE ANY CONTEXT
MANAGE ANY QUEUE
GLOBAL QUERY REWRITE
QUERY REWRITE
DROP ANY OPERATOR
EXECUTE ANY TYPE
CREATE ANY MATERIALIZED VIEW
CREATE MATERIALIZED VIEW
CREATE PUBLIC DATABASE LINK
CREATE DATABASE LINK
CREATE ANY SYNONYM
ALTER ANY CLUSTER
DROP USER
MANAGE TABLESPACE

Know the indian counterpart of Sarbanes-Oxley Act of 2002. Corporate responsibility.

SOX and its counterparts the world over(Sarbanes-Oxley Act of 2002. Corporate responsibility.)

Name of the SOX counterpart	Country/Geography	Date of effect
J-SOX	Japan	April 2008
CLERP 9 (Corporate Law Economic Reform Program (Audit Reform and Corporate Disclosure) Act 2004)	Australia	2004
Bill 198 (Canadian Sarbanes-Oxley Act or C-SOX)	Ontario, Canada	October 1, 2003
Clause 49	India	December 2005
Euro-SOX (The 8th EU Directive or the audit directive)	European Union (EU)
Combined Code of Corporate Governance	England	1998
Law 262/2005 (The protection of savings and regulation of financial markets)	Italy	2005
Financial Security Law of France (LSF or Loi sur la Sécurité Financière)	France	July 17, 2003

India:-

The term ‘Clause 49’ refers to clause number 49 of the Listing Agreement between a company and the stock exchanges on which it is listed (the Listing Agreement is identical for all Indian stock exchanges, including the NSE and BSE). This clause is a recent addition to the Listing Agreement and was inserted as late as 2000 consequent to the recommendations of the Kumarmangalam Birla Committee on Corporate Governance constituted by the Securities Exchange Board of India (SEBI) in 1999.

• As per Clause 49, for a company with an Executive Chairman, at least 50 per cent of the board should comprise independent directors. In the case of a company with a non-executive Chairman, at least one-third of the board should be independent directors.

• It would be necessary for chief executives and chief financial officers to establish and maintain internal controls and implement remediation and risk mitigation towards deficiencies in internal controls, among others.

• Clause VI (ii) of Clause 49 requires all companies to submit a quarterly compliance report to stock exchange in the prescribed form. The clause also requires that there be a separate section on corporate governance in the annual report with a detailed compliance report.

• A company is also required to obtain a certificate either from auditors or practicing company secretaries regarding compliance of conditions as stipulated, and annex the same to the director's report.

• The clause mandates composition of an audit committee; one of the directors is required to be "financially literate".

• It is mandatory for all listed companies to comply with the clause by 31 December 2005.