Got some queue tables which I want people to be able to select one to see the contents.


I have this table xxxqtab and a role which i want to assign access to

grant select on xxxqtab to read_only_role;

ERROR at line 1:
ORA-01720: grant option does not exist for 'SYS.AQ$_JMS_OBJECT_MESSAGE'

anyway of granting access to view these tables only (the role has only create session and grants on other tables) redhat 2.1