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

Thread: ORA-01935 during alter user

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    ORA-01935 during alter user

    Hi,

    when i alter a particular user i am getting this error.

    alter user scott identified by tiger

    ORA-01935: missing user or role name
    But for other users it is working fine

    can somebody help

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Make sure user scott exist in database. Maybe it was created with upper case letters. In that case you many want to use double quotes around SCOTT.
    -- Dilip

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