Ex/Import of a user scheme with all privileges [message #74292] |
Tue, 02 November 2004 19:19 |
LS2
Messages: 1 Registered: November 2004
|
Junior Member |
|
|
I tried to find a Solution to use the Export/Import Utilities to perform a copy of a user scheme (only all privileges with all roles) from one DB in another. I use Oracle8.7. Is there a possibility to do this?
Another of my problems is, that i donīt know if i can delete all data in a db (with the import tool..f.e with a special import mode???) befor importing new data.(f.e: to delete a special user, who the dataīs belong to)
thx...
LS2
|
|
|
Re: Ex/Import of a user scheme with all privileges [message #74293 is a reply to message #74292] |
Wed, 03 November 2004 02:12 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
1. ROLES are database wide and NOT specific to a schema.
So you need to recreate the roles in you target database.
During import , oracle will try to grant privs in target as-is ( retreived from dump file). System privs will hold good (systemwide) and specific object privs depends on the dependency.
2. BY default you will append data during import.
You cannot delete it before import USING exp/imp.
You need to manually delete ( truncate the table data).
|
|
|