Hello, can someone help me
I'm logged on as user ISH. the following privileges are granted
select any dictionarywhen i execute:
select any table
select * from ctxsys.ctx_indexesit works fine..
but when i want to create a stored procedure which makes use of the above statement:
CREATE OR REPLACE PROCEDURE ISH.APPLSP_GETFULLTEXTSTATUS AS
select * from ctxsys.ctx_indexes
it fails with the following error message :
PL/SQL: ORA-00942: table or view does not exist
however when I execute
GRANT SELECT ON ctxsys.ctx_indexes TO ISHi can create the stored procedure. But this seems strange to me since the user ISH is aready GRANTED to select from the table ctxsys.ctx_indexes..
Are there some different privileges for selecting data from tables normaly and from within a stored procedure?
thanks for reading Bart Rouw