1

What privileges do you need to be able to query the sys.obj$, sys.col$ etc system tables directly?

thecoop
  • 45,220
  • 19
  • 132
  • 189

1 Answers1

1

For Oracle 9i or later, the SELECT_ANY_DICTIONARY privilege.

For earlier versions, I think you need SELECT_ANY_TABLE, and you would also need to have 07_DICTIONARY_ACCESSIBILITY = TRUE, but this is unsafe.

Igby Largeman
  • 16,495
  • 3
  • 60
  • 86