how to grant privilege on a specific schema instead of full database
Hi,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
glad I could help
ASKER