DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Apr 2003
    Posts
    19

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

    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
    sknaidu

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    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
  •  


Click Here to Expand Forum to Full Width