problem with grant on users
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: problem with grant on users

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    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
    Aug 2002
    Posts
    35
    what is '00855000'
    you can grant these privlages to a user so use the actual username in place of this no.
    "Be not afraid of growing slowly. Be afraid only of standing still."

  3. #3
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    post the result of select * from dba_users where username='00855000';

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    User names that begin with a digit have to be enclosed in double-quotes ...
    Code:
    grant alter, select, insert, update on tab1 to "00855000";
    Personally, i think it's a bad idea to have these names.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Nov 2001
    Posts
    335
    I agree, it is a bad idea to have names like this. You may have a problem if you are planning to use dynamic sql in PL/SQL and manipulate with those username and PL/SQL
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    WHO CARES!!!

    They are "USERS" and not worthy of your (our) time!!

    Give them nothing!! Let them eat cake!!

    With sincere empathy for mankind;

    MH
    I remember when this place was cool.

  7. #7
    Join Date
    Nov 2001
    Posts
    335
    Originally posted by Mr.Hanky
    WHO CARES!!!

    They are "USERS" and not worthy of your (our) time!!

    Give them nothing!! Let them eat cake!!

    With sincere empathy for mankind;

    MH
    Good point! Except they are paying the bill.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    My job would be easy if I didn't have to deal with users, hardware, or software...
    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."

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by marist89
    My job would be easy if I didn't have to deal with users, hardware, or software...
    That would leave you with nothing to do other than "interface" with management. I think you need to exclude them also. Maybe they should be first on the list.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  10. #10
    Join Date
    Feb 2001
    Posts
    295
    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

    Try this:

    grant alter, select, insert, update on tab1 to "00855000";
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

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