DESCRIBE and ORA-00942
I connect as user SYSTEM and try to query a user schema (US) :
SELECT * FROM US.USER_TABLES; --> error ORA-00942
But, DESCRIBE US.USER_TABLES works fine.
I can understand why SELECT fails, but not why DESC succeeds.
Any explanation ?
But, DESCRIBE US.USER_TABLES works fine.
I can understand why SELECT fails, but not why DESC succeeds.
Any explanation ?
0