User with DBA role cannot select any data...
106990Jul 27 2003 — edited Jul 31 2003Hi all,
Oracle 8i on solaris is the setup.
I have two tables, one called employee and the other department.
The owner of the schema can select from both these tables.
The ops$ account which is assigned the dba_role and has 'select any table' privilage, but they cannot select from the employee table but can select from the department table.
How is this happening, I would have thought the 'select any table' would enable it to select from any table?
All help appreciated,
Yours confused,
Rob