meta | Gioorgi

SQL Server: meta programmazione e meta descrittori

February 6, 2011 February 21, 2019 / Italian Content, Structured Query Language (SQL) / c#, meta, sql, sqlserver

In questo articolo della serie SQL Server, vedremo come creare in modo dinamico delle istruzione per impostare delle policy di sicurezza. Creeremo da zero una stored procedure chiamata sp_FixOverallGrant che in modo dinamico imposterà i profili di sicurezza per due utenze, una in lettura e scrittura (EBRB0_APP) ed una in sola lettura (EBRB0_USR). In particolare …

SQL Server: meta programmazione e meta descrittori Read More »

oracle mass table drop

July 3, 2007 January 18, 2009 / English Content, Legacy ObjectsRoot.com / build, easy, meta, oracle, postgresql, script, small, sql, table, ui, vi

Sometimes I need to build a small script to delete a huge set of tables of a schema. In Oracle is easy to do it, using the meta tables "all_tables", "all_views", and "all_sequences": select 'drop table ' || table_name || ' cascade constraints;' from all_tables where owner='protoss' and table_name not like 'BIN%';select 'drop view …

oracle mass table drop Read More »

The Project Manager

June 28, 2006 January 18, 2009 / English Content, Legacy ObjectsRoot.com / ant, evil, fini, java, linux, meta, programming, project, provider, steve, trouble, ui, vi

Steve is not a normal solution provider.
Steve is the final destination for Project Management troubles.
Let’s see how Steve can solve problems