Oracle Database Discussions

Oracle Database 10g

Red Hat Enterprise Linux Server release 5.3


We are requested by a developer to grant his account read only access to TABLES, VIEWS, INDEXES, SEQUENCES, FUNCTIONS, PROCEDURES, PACKAGES, TRIGGERS, JOBS of another schema.

I know granting read only access to Tables and Views. But is it possible to grant READ ONLY access to other mentioned objects ? How to do it ?

And some views are in INVALID status.

I tried to compile them using alter view owner.viewname compile;

But got this ---- Warning: View altered with compilation errors.

Those views are still in INVALID status. And then I tried to use utlrp.sql . Same result.

Then I used the following

SELECT TEXT FROM DBA_VIEWS WHERE VIEW_NAME='view-name';

select REFERENCED_NAME,REFERENCED_TYPE from dba_dependencies where name='view-name';

It turns out some reference types are non existent.

Does that mean DBAs cannot do anything about this ?