Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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.
Asked:
2
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
you can, as in your other question, specify which schema you want to export
specify
owner=abc
instead of
full=Y
on your exp command line.