SRB:SQLTricks: Difference between revisions
From Adapt
No edit summary |
(No difference)
|
Latest revision as of 17:41, 16 September 2008
- Add uid 102 all(999) access to files
- insert into mdas_ad_grp_accs select data_grp_id,102,999 from mcat.MDAS_TD_DATA_GRP t1 where t1.data_grp_id like '0002.0009.0001.0001.0001.%%'
- Delete tickets to allow for collection deletion
- delete from mdas_au_tckt_grp where data_grp_id like '0002.0009.0001.0001%%'
- delete all metadata where filename is 18*TIF
- delete from mdas_ad_mdata where data_id in (select data_id from mdas_ad_repl where data_name like '18-%.TIF')
