| USER PRIVS Migration from 9i to 10g [message #276969] |
Sat, 27 October 2007 10:19  |
seethem
Messages: 41
Registered: September 2007
|
Member |
|
|
Gurus et al,
QUESTION
============
* How do I migrate all the roles/object & system privileges for a schema from 1 database to another?
BACKGROUND INFO
==================
I inherited a database with little to no documentation about how it was built, what roles, system privileges, object privileges to assign to the database users.
I am interested in moving a 9i enterprise edn database into a 10g enterprise edition database RAC.
Both sit on windows 2003 Enterprise.
IDEA
=======
* We currently are interested in using EXP/IMP method.
* On the 10g database recreate the schema. Assign all the necessary roles/system privileges to the schema.
* We are able to determine the session privileges (session_privs view)
* Unsure that this is the best method.
Please share what you think/ How it can be done?
|
|
|
|
|
|
| Re: USER PRIVS Migration from 9i to 10g [message #276978 is a reply to message #276971] |
Sat, 27 October 2007 11:43  |
seethem
Messages: 41
Registered: September 2007
|
Member |
|
|
Bare with me Michael please,
Basically, I use the EXP utility to export the database full.
Then, I am simply creating the same tablespaces, users, their roles and assigning the quota unlimited to their tablespaces on the new database. Just as it was on the old database.
Finally, I use the IMP utility to import into the schemas (from user to user). All the object privileges that were present for the database users in the old database would be present in the new?
Do I have the process correct.
Thanks in advance.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
