Wednesday, May 23, 2007

After Food Poisoning Gas

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

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!