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

Thread: Errors when granting privileges for new user

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    83

    Exclamation

    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?

    Thanx
    Fiona

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Did you perform a recovery lately? The missingNNN file name usually comes up after a recovery.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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