Groovy DBA

  [root@tmwuvdb01 ~]# passwd -S wcadmin wcadmin LK 2011-02-10 0 99999 7 -1 (Password locked.)

  SELECT      TRIGGER_SCHEMA,      TRIGGER_NAME,      EVENT_OBJECT_TABLE AS 'TABLE_NAME',      DEFINER  FROM information_schema.TRIGGERS  WHERE TRIGGER_NAME = 'after_mao_inventory_insert'; SELECT      TRIGGER_SCHEMA,      TRIGGER_NAME,      DEFINER  FROM information_schema.TRIGGERS  WHERE TRIGGER_NAME = 'after_mao_inventory_insert';

 SELECT GRANTEE, TABLE_SCHEMA, TABLE_NAME, PRIVILEGE_TYPE  FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES  WHERE TABLE_NAME = 'MAO_INVENTORY_TRACKING';

 > net user /domain username   H:\>net user /domain gm15 The request will be processed at a domain controller for domain tmw.com. User name                    GM15 Full Name                    Murugappan, Gillian  (GM15) Comment User's comment Country/region code          000 (System Default) Account active               Yes Account expires              Never Password last set            5/25/2026 7:27:09 PM Password expires             8/23/2026 7:27:09 PM Password changeable          5/26/2026 7:27:09 PM Password required            Yes User may change password     Yes Workstations allowed         All Logon scr...

  select table_schema as database_name,        table_name,        round( (data_length + index_length) / 1024 / 1024, 2)  as total_size,        round( (data_length) / 1024 / 1024, 2)  as data_size,        round( (index_length) / 1024 / 1024, 2)  as index_size from information_schema.tables where table_schema not in ('information_schema', 'mysql',                            'performance_schema' ,'sys')       and table_type = 'BASE TABLE'       -- and table_schema = 'your database name' order by total_size desc limit 10;

  https://oem15db601.tmw.com:7803/em sysman / oms_newLife3