Read only access

[fidelfs]

Our company finally made the decision to change apps password for our production installation.

We have 11.5.8 version and 8i.

DBA's have assigned a new id for each developers and support team with select only access to apps objects.
We are able to connect and work but browser does not work anymore. What the DBA's are missing. We have access to select all apps object but browser does not retrieve a single object.

Please help.

 

[Marco Kalter]

The minimal select privileges that are required by the object browser is on the sys.all_objects view. To drill down into individual folders such as tabe columns and program unit parameters you will need select privileges on sys.all_tab_columns and so on.

 

[fidelfs]

I have select privileges on those tables. I can query them as: select * from sys.all_objects and see the packages.

Browser does not work. We did not have access to DBA views. Could be that the reason?

 

[Marco Kalter]

No, this should be sufficient. I can only imagine that:

1. You have selected a Browser Filter with a where clause that will not return any records.

2. You have enabled the "Use DBA views if available" preferemce, and there is some problem with the sys.dba_objects view.

Can you verify this?

 

[fidelfs]

1. I tried all the filters even the default ones like "All Objects" wich has no modification.

2. I have removed that option and I got the same result.

Please advise.

 

[Marco Kalter]

You mention "packages" in a previous post. Is the problem limited to packages?

 

[fidelfs]

No, It is the same tables, views, etc.

I am not able to see anything.

 

[Marco Kalter]

Send me an e-mail and I will send you a debug version.

 

[canadj]

I think this is how I resoved this issue, will require dba access to issue grant.

GRANT SELECT ON dba_objects TO &Ouser;