|
-
Re: Ora-01917 : User Or Role "stage" Does Not Exist.
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|