problem with grant on users
hi,
what is '00855000'
"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!!!
I remember when this place was cool.
Originally posted by Mr.Hanky
WHO CARES!!!
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...
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
An ounce of action is worth a ton of theory.
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
Reply With Quote
Bookmarks