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

what is '00855000'
you can grant these privlages to a user so use the actual username in place of this no.

post the result of select * from dba_users where username='00855000';

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.

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

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

Quote:

---

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.

My job would be easy if I didn't have to deal with users, hardware, or software...:rolleyes:

Quote:

---

Originally posted by marist89
My job would be easy if I didn't have to deal with users, hardware, or software...:rolleyes:

---

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.

Quote:

---

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";