I have created role role_A and granted select any table system privileges to role_A. I have also created user A.
I grant the role_A to user A. However, when I login to user A I could not select any tables. What's wrong here? Is there a scrip I need to run to enable this feature. It seems like all of the privileges I grant through a role do not work. I have to specifically grant privileges to user.
Please help! Thanks,
Just a hunch if you are using pl/sql to select any table then the grant needs to be an explicit grant of the privilege to the user. Otherwise, I'm not sure what the issue is.
I belive your problem is not related to roles, but to synonyms.
Create synonym you want to select from, or use full name notation:
SELECT * FROM table_owner.table_name;
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Thanks for the help. gandolf989 reminds me to check it through sql plus. It works there. It just does not work through SQL Navigator. May be some set up in SQL Navigator is not right.
Click Here to Expand Forum to Full Width