data-dictionary – Tarik Billa

lower_case_table_names Settings in MySQL 8.0.12

April 8, 2024 by Tarik

So far, I can get it to work with a workaround (I originally posted on askubuntu): by re-initializing MySQL with the new value for lower_case_table_names after its installation. The following steps apply to a new installation. If you have already data in a database, export it first to import it back later: Install MySQL: sudo … Read more

Is there a way to do full text search of all oracle packages and procedures?

May 6, 2023 by Tarik

You can do something like SELECT name, line, text FROM dba_source WHERE upper(text) like upper(‘%<<your_phrase>>%’) escape ‘\’

Check Postgres access for a user

February 8, 2023 by Tarik

You could query the table_privileges table in the information schema: SELECT table_catalog, table_schema, table_name, privilege_type FROM information_schema.table_privileges WHERE grantee=”MY_USER”