Wednesday, September 17, 2008

Privileges in EXP_FULL_DATABASE and IMP_FULL_DATABASE

What are the Privileges exist for EXP_FULL_DATABASE and IMP_FULL_DATABASE ?

Here we go,


FOR EXP_FULL_DATABASE


BACKUP ANY TABLE
SELECT ANY TABLE
SELECT ANY SEQUENCE
EXECUTE ANY PROCEDURE
EXECUTE ANY TYPE
ADMINISTER RESOURCE MANAGER
RESUMABLE
READ ANY FILE GROUP


FOR IMP_FULL_DATABASE

CREATE TABLESPACE
DROP TABLESPACE
CREATE USER
BECOME USER
DROP USER
CREATE ROLLBACK SEGMENT
DROP ROLLBACK SEGMENT
CREATE ANY TABLE
ALTER ANY TABLE
DROP ANY TABLE
COMMENT ANY TABLE
SELECT ANY TABLE
INSERT ANY TABLE
UPDATE ANY TABLE
CREATE ANY CLUSTER
DROP ANY CLUSTER
CREATE ANY INDEX
DROP ANY INDEX
CREATE ANY SYNONYM
DROP ANY SYNONYM
CREATE PUBLIC SYNONYM
DROP PUBLIC SYNONYM
CREATE ANY VIEW
DROP ANY VIEW
CREATE ANY SEQUENCE
DROP ANY SEQUENCE
CREATE DATABASE LINK
CREATE PUBLIC DATABASE LINK
DROP PUBLIC DATABASE LINK
CREATE ROLE
DROP ANY ROLE
AUDIT ANY
CREATE ANY PROCEDURE
ALTER ANY PROCEDURE
DROP ANY PROCEDURE
EXECUTE ANY PROCEDURE
CREATE ANY TRIGGER
ALTER ANY TRIGGER
DROP ANY TRIGGER
CREATE PROFILE
DROP PROFILE
ANALYZE ANY
CREATE ANY MATERIALIZED VIEW
DROP ANY MATERIALIZED VIEW
DROP ANY DIRECTORY
CREATE ANY TYPE
ALTER ANY TYPE
DROP ANY TYPE
EXECUTE ANY TYPE
CREATE ANY DIRECTORY
CREATE ANY LIBRARY
DROP ANY LIBRARY
CREATE ANY OPERATOR
DROP ANY OPERATOR
CREATE ANY INDEXTYPE
DROP ANY INDEXTYPE
GLOBAL QUERY REWRITE
CREATE ANY DIMENSION
DROP ANY DIMENSION
MANAGE ANY QUEUE
CREATE ANY CONTEXT
DROP ANY CONTEXT
DROP ANY OUTLINE
ADMINISTER RESOURCE MANAGER
ADMINISTER DATABASE TRIGGER
RESUMABLE
DROP ANY SQL PROFILE
CREATE ANY SQL PROFILE



have a nice day.......................
The art of being wise is knowing what to overlook.
William James

No comments: