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
] 
Blog
Search
Help
Members
Register
Login
Home
