Granting object privileges to new tables 1

[nuct]

Hi, I've just made a new table and have granted the necessary privilages to it (i think), but for some reason when i try run a report involving it using Scribe it says 'table no found' or something to that effect. I used:

GRANT ALL
ON CROSS_REF (new table name)
TO ALL

to try and give access to the table to all users. Do i need to do someting else? The report works fine when i log into scribe as dba.

Any help would be much appreciated.

Simon.

 

[lfoata]

When you run it as a different user , did you put the owner as a prefix to the table_name:
ex: owner.cross_ref

The other way is to create a public synonym to your table without the owner as a prefix.

 

[nuct]

Thanks for that, it did the trick.

Simon.