| Full Database Export Import (Privileges not getting granted) [message #72844] |
Sun, 16 November 2003 08:04  |
Prashant Nair
Messages: 8
Registered: November 2003
|
Junior Member |
|
|
Hi all,
I have taken a full database export from db1 which had some users. Now these users had object privileges granted to each other and also had some privileges on objects owned by sys. I want to import the entire database to another db (db2) which is totally fresh. I precreated the tablespaces in db2 and then did a full database import. Now as expected the users got created in db2 and also had the relevant roles and privileges granted to them except for the object privileges that they had on objects owned by sys (eg select on V_$PARAMETER, execute on DBMS_PIPE,... etc).
So I expect that when we do a full database import all the users, roles etc get created and the various privileges that they have on each others objects and also other privileges get granted to them automatically.
Can someone please tell me why the object privileges did not get granted to the users and is my expecation correct or is there something I am missing.
Thanking you all in anticipation.
Prashant
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
