Hi
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,
YM