Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: problem with grant on users

    hi,
    I run this query:

    grant alter, select, insert, update on tab1 to 00855000;

    but I get this error:
    ERROR at line 1:
    ORA-00987: missing or invalid username(s)

    The user 00855000 exist!

    What I wrong?
    Thanks
    Raf

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    Quotes

    Change your statement to :

    grant alter, select, insert, update on tab1 to "00855000"
    /

    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    Are you a collegue of jortiz?



    See

    http://www.dbforums.com/t970551.html

    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333
    HI,

    The reason for ORA-00987: missing or invalid username(s) error is

    No username was specified in a GRANT statement or one of the specified usernames is invalid.

    Valid usernames must be specified following the keyword TO in a GRANT statement to define a user.

    A username must begin with a letter, consist only of alphanumeric characters and the special characters $, _, and #, and be less than or equal to 30 characters.

    If it contains other characters, it must be enclosed in double quotation marks. It may not be a reserved word.
    SATHISH .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •