Ora-01917 : User Or Role "stage" Does Not Exist.

[SKNaidu]

Hi Friends

When Iam trying to import the dump file in to one user's schema.iam getiing the errors like


"GRANT UPDATE ON "ACCOUNT_MASTER" TO "STAGE"
ORA-01917 : USER OR ROLE "STAGE" DOES NOT EXIST.


"GRANT SELECT ON "ACCOUNT_MASTER" TO "ACTIVE_REPORTS"
ORA-01917 : USER OR ROLE "ACTIVE_REPORTS" DOES NOT EXIST.

The Export file was taken at client's place,But iam not sure about the contents of Export file.

The user(which i created for importing this dumpfile) has given roles like "connect,resource,dba".

Please advice me in this regard.



Thanks With regards

[ggnanaraj]

Originally posted by SKNaidu

"GRANT UPDATE ON "ACCOUNT_MASTER" TO "STAGE"
ORA-01917 : USER OR ROLE "STAGE" DOES NOT EXIST.

"GRANT SELECT ON "ACCOUNT_MASTER" TO "ACTIVE_REPORTS"
ORA-01917 : USER OR ROLE "ACTIVE_REPORTS" DOES NOT EXIST.

The object 'account_master' belongs to user1 (assume). Now update privs on 'account_master' is to be granted to database user or role 'stage', by user1.

This fails as the database into which you are importing this dump file does not have an user or role called 'stage'. Thats it!

So, create an user or role called 'stage' (as per your requirement) to handle this error.

HTH.