Folks as it is very urgent pls get me an idea on this
We have a schema owner called' pv'.and i created a role called 'pvapp' with grant select on xxx to pvapp.
And now i created a user 'pvappserver' with only connect role and also i granted with 'pvapp' role which i created .
Now when i login as pvappserver and try to select from xxx table it returns me with table or view not found.
I think im missing something while creation of role..or ..
could u pls let me know on this ..very urgent.
thnks oracle on 8.1.5 and on solaris 2.7
Click Here to Expand Forum to Full Width