This content has been marked as final. Show 6 replies
What database version are you connected to?
and the Ordinary 10.2.0.4
Well, I cant see an ordinary developer (even one who has to tune/write/test/etc) the application being granted DBA role. What are the roles required to get this to work?
No time to research this thoroughly just now, but you do not need the DBA role. If you don't wish to follow the guidelines in the other links, or if they don't apply to your DB version, then probably, at a minimum, something quick and dirty like...
should do the trick. Also I saw a mention of
grant select any dictionary to <myuser>; grant execute on dbms_workload_repository to <myuser>;
grant advisor to <myuser>;so that may be required for certain bits of the report -- not sure.
Thanks. I will ask for those grants.