?
Solved

how to grant privilege on a specific schema instead of full database

Posted on 2009-04-07
3
Medium Priority
?
749 Views
Last Modified: 2013-12-18
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.
0
Comment
Question by:gudii9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 24093444
you can't have export privileges for a specific schema

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.



0
 
LVL 7

Author Closing Comment

by:gudii9
ID: 31567827
thank you very much. I appreciate it
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 24134269
glad I could help
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question