ORA-01919
I have always maintained that the name "Oracle" was due to the skills of divination needed to interpret the error messages ..
Here's one more example, from a colleague who wanted sottopostomi gods ... (Oracle 10.2.0.1)
system> create user IDENTIFIED BY foo foo;
Created user.
system> alter user default role connect foo, foo
alter user default role connect
* ERROR at line 1: ORA-01919
: role 'CONNECT' does not exist
system> grant connect to foo;
Grant succeeded.
system> alter user default role connect foo;
Modified user.
So ... the problem is trivial ... you can not tell the database to set a specific default role to a user if this user does not have first assigned the role .. okay ...
Of course the error message could be clearer ... (I would have expected a ORA-01924:, role 'string' not Granted or does not exist ").
It 's like a football midfielder told a "day games start as a goalkeeper" and instead of answering "But I never did the doorman!" say "Look at that in football you do not use gatekeepers!"
Wednesday, May 23, 2007
Thursday, May 17, 2007
Inside Of Nostril Hurts
unoraventiseiminutiequarantaseisecondi!! Big mistake
Ok ... I am very happy .. At this year
Straberna (www.gpbern.ch) I managed to improve my time on the 16 Km of about 7 minutes!
And I still have room for improvement (trad: I finally broke).
Many thanks to Julia and Vinz for the hospitality and congratulations to her for more than Fabietto Mr 1:28:10 (If you arrive before me, I'm breaking the legs :-)
And on Sunday .. . Straverona!
Ok ... I am very happy .. At this year
Straberna (www.gpbern.ch) I managed to improve my time on the 16 Km of about 7 minutes!
And I still have room for improvement (trad: I finally broke).
Many thanks to Julia and Vinz for the hospitality and congratulations to her for more than Fabietto Mr 1:28:10 (If you arrive before me, I'm breaking the legs :-)
And on Sunday .. . Straverona!
Subscribe to:
Posts (Atom)