AddSysAdminMember.sql 719 B

123456789101112131415161718
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2008, 2009
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
  10. -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
  11. insert into CMREFORD1 (PROPID, CMID, ORD, REFCMID)
  12. select 27, (select cmid from cmobjprops1 where objid='::System Administrators'),
  13. coalesce((select max(ord) from CMREFORD1 where propid=27 and cmid=(select cmid from cmobjprops1 where objid='::System Administrators')), -1)+1,
  14. CMID
  15. from CMOBJPROPS1 where OBJID='::Everyone'