how to grant privilege on a specific schema instead of full database
Till now I am granting privileges to schema/user as
grant resource, exp_full_database, imp_full_database, create session to xyz_user;
This is giving issues when I export, import into dump file by exporting entire database etc. How can i give the import, export privileges on one specific schema say 'abc' to user 'xyz_user' . Any sample code, links, resources highly appreciated.Thanks in advance.