Questions on data pump [message #536804] |
Fri, 23 December 2011 02:45 |
|
Jack14
Messages: 497 Registered: December 2011 Location: INDIA
|
Senior Member |
|
|
Hi,
1.I used the following query to see if the user 'TEST' has read,write privilege on directory objects and the output it was as below.
SELECT p.grantee, p.privilege, p.owner, d.directory_name
FROM dba_tab_privs p, dba_directories d
WHERE p.table_name=d.directory_name
AND (grantee IN ('TEST', 'PUBLIC')
OR grantee IN (SELECT granted_role FROM dba_role_privs
WHERE grantee IN ('TEST', 'PUBLIC')))
ORDER BY 4,3,2;
GRANTEE PRIVILEGE OWNER DIRECTORY_NAME
EXP_FULL_DATABASE WRITE SYS DATA_PUMP_DIR
IMP_FULL_DATABASE WRITE SYS DATA_PUMP_DIR
EXP_FULL_DATABASE READ SYS DATA_PUMP_DIR
IMP_FULL_DATABASE READ SYS DATA_PUMP_DIR
From the above output , i see column grantee has 'EXP_FULL_DATABASE' instead of 'TEST' user. can you explain about this?
2.Can you explain the relationship pertaining to tablespace on data pump?
Also why do we check whether user TEST has quota on which tablespaces in data pump?
Could you clarify the above questions?
Thank you
|
|
|
|
Re: Questions on data pump [message #536811 is a reply to message #536806] |
Fri, 23 December 2011 03:12 |
|
Jack14
Messages: 497 Registered: December 2011 Location: INDIA
|
Senior Member |
|
|
Michel,
Quote:Can you explain the relationship pertaining to tablespace on data pump?
Also why do we check whether user TEST has quota on which tablespaces in data pump?
Both the above questions are similar .Sorry for confusing.
Quote:
Is this an interview or homework question?
Homework question.
Thank you very much for your responds.
[Updated on: Fri, 23 December 2011 03:12] Report message to a moderator
|
|
|