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