DBA priveleges vanished
I performed an import of 4 users into a database.
Now, in those four schema's, even DBA has no priveleges even though the priveleges show up.
For example I am unable to compile and SP even logged on as SYS!
Any ideas on this?
Last edited by hemanr; 08-07-2003 at 02:52 PM.
Did you have the schema owner created before you imported? What kind of import did you do?
Life is a journey, not a destination!
3 users did not exist in the new database. Yes I created the users.
One of the users already existed with no objects.
This was an import by individual user from the dump, using Fromuser and Touser.
I have also found that one of the users imported has no privileges on its own objects!
It has no privileges on a view owned by itself!
Find out who the owner of the object is from dba_objects table. Then check what all privileges that user has. There must be some user who has privileges on these objects. Also check what were the privileges for that user in old database.
Click Here to Expand Forum to Full Width