This content has been marked as final. Show 4 replies
If permissions are not given, give permission and try againYou can use the old user as well but in that case you'll have to modify the query of existing reports.
Whenever you give permissions on some schema then you'll have to use SCEHMA_OWNER.TABLE NAME in FROM CLAUSE.
In your case,
Earlier: Select * from USR
After changes: Select * from DEV_OIM.USR
Use old user
Modify the from clause in reports