Home Verkennen Help
Registreren Inloggen
GlobalCube
/
analytics
3
0
Vork 0
Bestanden Issues 0 Pull-aanvragen 0 Wiki
Boom: 0a263e0aff
Aftakkingen Labels
analytics
/
configuration
/
schemas
/
content
/
sqlserver
/
AddSysAdminMember.sql

AddSysAdminMember.sql 719 B
Geschiedenis Ruwe

123456789101112131415161718 
  1. -- Licensed Materials - Property of IBM
    2. 

  2. --
    3. 

  3. -- BI and PM: CM
    4. 

  4. --
    5. 

  5. -- (C) Copyright IBM Corp. 2008, 2009
    6. 

  6. --
    7. 

  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
    8. 

  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
    9. 

  9. 

  10. -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
    11. 

  11. -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
    12. 

  12. 

  13. 

  14. insert into CMREFORD1 (PROPID, CMID, ORD, REFCMID) 
    15. 

  15. 	select	27, (select cmid from cmobjprops1 where objid='::System Administrators'),
    16. 

  16. 			coalesce((select max(ord) from CMREFORD1 where propid=27 and cmid=(select cmid from cmobjprops1 where objid='::System Administrators')), -1)+1, 
    17. 

  17. 			CMID
    18. 

  18. 	 from CMOBJPROPS1 where OBJID='::Everyone'
    19.