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
Printable View
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 ...
Personally, i think it's a bad idea to have these names.Code:grant alter, select, insert, update on tab1 to "00855000";
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
Good point! Except they are paying the bill.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
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:
Originally posted by marist89
My job would be easy if I didn't have to deal with users, hardware, or software...:rolleyes:
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";