关于expdp,impdp操作需要的权限(二)
62
GRANT execute any operator TO imp_full_database;
63
GRANT grant any privilege TO imp_full_database;
64
GRANT grant any object privilege TO imp_full_database;
65
GRANT grant any role TO imp_full_database;
66
GRANT select any table TO imp_full_database;
67
GRANT alter database TO imp_full_database;
68
69
70
71
-------------------------------------------------------------------------
72
-- Public view defs (DBA_/USER_*) go here.
73
-------------------------------------------------------------------------
74
75
-- Fixed (virtual) View Declarations, Synonyms, and Grants
76
CREATE OR REPLACE VIEW SYS.V_$DATAPUMP_JOB AS
77
SELECT * FROM SYS.V$DATAPUMP_JOB;
78
CREATE OR REPLACE PUBLIC SYNONYM V$DATAPUMP_JOB FOR SYS.V_$DATAPUMP_JOB;
79
GRANT SELECT ON SYS.V_$DATAPUMP_JOB TO SELECT_CATALOG_ROLE;
80
81
CREATE OR REPLACE VIEW SYS.V_$DATAPUMP_SESSION AS
82
SELECT * FROM SYS.V$DATAPUMP_SESSION;
83
CREATE OR REPLACE PUBLIC SYNONYM V$DATAPUMP_SESSION FOR
84
SYS.V_$DATAPUMP_SESSION;
85
GRANT SELECT ON SYS.V_$DATAPUMP_SESSION TO SELECT_CATALOG_ROLE;
86
87
CREATE OR REPLACE VIEW SYS.GV_$DATAPUMP_JOB AS
88
SELECT * FROM SYS.GV$DATAPUMP_JOB;
89
CREATE OR REPLACE PUBLIC SYNONYM GV$DATAPUMP_JOB FOR SYS.GV_$DATAPUMP_JOB;
90
GRANT SELECT ON SYS.GV_$DATAPUMP_JOB TO SELECT_CATALOG_ROLE;
91
92
CREATE OR REPLACE VIEW SYS.GV_$DATAPUMP_SESSION AS
93
SELECT * FROM SYS.GV$DATAPUMP_SESSION;
94
CREATE OR REPLACE PUBLIC SYNONYM GV$DATAPUMP_SESSION FOR
95
SYS.GV_$DATAPUMP_SESSION;
96
GRANT SELECT ON SYS.GV_$DATAPUMP_SESSION TO SELECT_CATALOG_ROLE;