This content has been marked as final. Show 4 replies
Grant SELECT rights on user1 table directly to the user2 instead of through role.
GRANT SELECT on USER1.TEST to USER2;
This should work!
Grant Select on USER2.TEST for CONNECT;
You are granting select on the TEST table owned by USER2, but according to the logic above that statement, USER1 owns the table. The grant should be:
BUT ... I would never grant privs to one of the system privs like CONNECT, RESOURCE, etc... You should create a role just for your users and grant access to that role instead. You can then grant that role to your different users.
Grant Select on USER1.TEST to CONNECT;
Also... if you didn't want to create another role you could always grant the privs to PUBLIC:
Just another option...
grant select on user1.test to PUBLIC;
I'm sorry, but none of the options, didnt work. :(
Nevermind, since I need them very urgently, i 'm just using "USER.TABLE" = select field1 from user1.test;