-
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.
"Be not afraid of growing slowly. Be afraid only of standing still."
-
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
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
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.
-
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!
-
My job would be easy if I didn't have to deal with users, hardware, or software...
Jeff Hunter
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|