Can someone please answer this and clear my confusion. I had to refresh some schemas in test from production on this oracle 10g database. I dropped the schemas, imported them using data pump. I then created a grant file using the same dump file and ran the grant file as sys. Is this enough to create the grants? What needs to be done to make sure that all these schema grants were all the same as before the import.... I am asking this because one of the application logics is not working and I am still not sure if it is a role/grant thing that is causing this.