Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
when executing the following sql from sqlplus -
select count(table_name)
from all_tables
where owner = 'TEST1';
while logging as a user say (test3 with sysdba priv) Iam getting 2, the same sql when called from an SP its giving a value of 0. The SP is created by test3. Any idea?
select count(table_name)
from all_tables
where owner = 'TEST1';
while logging as a user say (test3 with sysdba priv) Iam getting 2, the same sql when called from an SP its giving a value of 0. The SP is created by test3. Any idea?