I think you're forgetting to make the newly created role a member of the user's default role.
Try this, I'm sure it will solve your problem.
Grant "pvapp" to "pvappserver";
Alter user "pvappserver" default role all;
Thanks,
Robel Girma
|
Results 1 to 7 of 7
Thread: simple issue rgdg role --urgentThreaded View
|
Click Here to Expand Forum to Full Width |