granting access to queue tables
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)
220.127.116.11 redhat 2.1
running the grant as sys fixed it
Click Here to Expand Forum to Full Width