DBA priveleges(funny scenario)

Hi Gurus,

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?

Thanks!

Did you have the schema owner created before you imported? What kind of import did you do?

Sam

Hi Sam,

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!

Any ideas?

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.