Oracle Migration 9 to 11g grants missing
Home > IT Answers > Oracle > Oracle Migration 9 to 11g grants missing
ITKE
10345 pts.
0
Q:
Oracle Migration 9 to 11g grants missing
Oracle 11g, Oracle 9, Oracle migration
a user get
the 'table or view does not exist' error after migration from Oracle 9 to 11g
- even though in the DD I can see owner grants select on the tables to
role -> role is granted to the user (only grants direct to user are
working fine)

Software/Hardware used:
Oracle 11g
ASKED: Oct 5 2009  8:55 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
KingFroggyDba
15 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You may need to run...

ALTER USER <USERNAME> DEFAULT ROLE ALL;

for each user with the problem.
Last Answered: Oct 6 2009  1:14 PM GMT by KingFroggyDba   15 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0