Toad World® Forums

how to Block code access in sqlnav


Hi all,

i’ve discovered lately that any user from other database can have access to the script of another one. when i use for example a search of a package and i specify a database where i’m not connected, it displayes the script… and it should not

i don’t know if i’m clear… i want to know where should i look, in ORACLE or sqlnav… and what to do to avoid this

thank you very much for your help



I do not understand exactly what you mean

But SQL Nav doesn’t give more special permissions
check Oracle permissions you have
For instance
If you have execution permissions you can see the spec
If you have debug permissions you can see the code