Errors when granting privileges for new user Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Errors when granting privileges for new user

  1. #1
    Join Date
    Nov 2000


    When I tried to grant "create procedure" and "select all table" to a new user, it gave me the following error

    ORA-604: error occurred at recursive SQL level 1
    ORA-376: file 43 cannot be read at this time
    ORA-1111: name for datafile 43 is unknown - rename to correct file
    ORA-1110: datafile 43:'c:\orant81\database\missing00043'

    I have no trouble with granting other privileges, just the above two.
    And neither me or the other DBA here has seen this error before - if there is problem with the database it needs resolving today.

    Has anyone encountered similar error before? If so, how was it resolved?


  2. #2
    Join Date
    Nov 2000

    Did you perform a recovery lately? The missingNNN file name usually comes up after a recovery.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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