thanks mufasa.
That works, but with the priviledge I gave userRO, it cannot do anything else only read access, correct?
GRANT CONNECT,
CREATE SESSION,
SELECT ANY TABLE to userRO;
I see some post that says for read only , only grant connect and create session.. but how do...