HI All,
I am able to access .
select * from dba_directories and i am able to view the data.
I have a plsql package . Inside package i have a piece of code where i am using dba_directories and selecting a directory from dba_directories and assigning to a variable.
while compiling the package it is showing table or view does not exist. but when i gave the GRANT ALL ON SYS.DBA_DIRECTORIES TO USER; Now the package is valid. My question is here before giving grants i was able to select then why package was showing invalid.