How to copy the grants given to a user to another

Suppose that you have a user USER_BASE that grant rights to USER1 and you want to grant those same rights to USER2.
You can use the following script in USER_BASE (change USER1 and USER2 literals for your user names) and run the output in USER_BASE.

How to copy synonyms from one user to another

Several times I'm asked this question:
How to copy synonyms from one user to another?

Here is the script you should use in the original user

Oracle SQL Developer Data Modeler is now Free!

If you, like me, missed the news be aware that Oracle SQL Developer Data Modeler is now Free! (I think you already knew that from the title of this post :-))

Quem está farto da música do Pingo Doce?

Para esses o Jaimão fez uma versão para maiores de 16 anos...(talvez...sei lá)

100 anos de República!

Parabéns à República (de Portugal) pelo seu aniversário.

Hoje cheguei à conclusão que a idade da reforma em Portugal nunca deveria ultrapassar os 64 anos, pois foi essa a idade em que a República Portuguesa teve uma grande reforma.

Oracle Magazine September/October 2010 available

	September/October 2010
Click the image to look inside

Update: direct link for facebook version (it doesn't need subscription info)

Oracle 12x?

In a group forum I follow in linkedin appeared this question:

What would be the letter to be used in the next version of Oracle Database: 12.
My answer was:
If they change from 12g my bet would by 12e for exadata or just for logic.
What logic?
8i..10g..12e..14c..16a
I know you can figure out the logic behind that :-)

What do you think?

TIOBE Programming Community Index for September 2010

PLSQL in 20th in TIOBE index (September 2010) was 14th last year (September 2009) and 13th two years ago (September 2008).

QEM 1.4.0 available

A new version (1.4.0) of Quest Error Manager is available

Changes since previous version (1.3.8)
----------------
* add error_category_name field to error_info_rt
* minor re-factoring
* add more last_* functions and last_error_info function to return the record
* add option to disregard the remaining_context in the message

Rossana

Hoje devido a uma conversa ao almoço recordei que aina não tinha mencionado aqui a Rossana.
Esta cantora Espanhola é uma das perferidas pelo meu filho para dormir no automóvel.
Eu acho que ela tem umas músicas alegres e positivas com um jeito muito latino.
Aqui vou deixo algumas das suas canções que o meu filho gosta.