Extracting Privilege Sets and ACL Codes from DB2 Content Manager for z/OS

Abstract

This document shows you how to extract privilege sets and ACL codes from IBM DB2 Content Manager for z/OS.

Contents


You can use SQLs against the Content Manager Library Server tables to obtain privilege sets and ACL codes. The SQLs can be run either from a DB2 command window on a Microsoft Windows workstation or from SPUFI under TSO.

Before you begin, it is important to understand that for the provided SQLs, you must modify the schema name IFVTW to the one you use for your Library Server tables.

Extract information on privilege sets

To extract information on privilege sets from Content Manager, you can use the following sample SQL code:

select KeywordClass, LanguageCode, KeywordCode,
KeywordName PrivsetName, KeywordDescription PrivsetDescription
from ifvtw.icmstnlskeywords
where keywordclass = 11
order by languagecode, keywordcode;

The output should be similar to the following output:

KEYWORDCLASS LANGUAGECODE KEYWORDCODE PRIVSETNAME
------------ ------------ ----------- --------------------------------
11 ENU 0 PrivilegeSet
11 ENU 1 AllPrivs
11 ENU 2 NoPrivs
11 ENU 3 SysAdminCM
11 ENU 4 SysAdminSuper
11 ENU 5 ClientUserCreateAndDelete
11 ENU 6 ClientUserReadOnly
11 ENU 7 UserDB2Connect
11 ENU 8 UserDB2TrustedConnect
11 ENU 9 SysAdminEIP
11 ENU 10 ClientUserEdit
11 ENU 11 ClientUserAllPrivs
11 ENU 12 SysAdminSubDomainCM
11 ENU 13 LibrarianInfoMining
11 ENU 14 UserInfoMining
11 ENU 15 SysAdminSubDomainEIP

16 record(s) selected.

Extract information on ACL codes

To extract information on ACL codes from Content Manager, you can use the following sample SQL code:

select KeywordClass, LanguageCode, KeywordCode,
KeywordName ACLname, KeywordDescription ACLDescription
from ifvtw.icmstnlskeywords
where keywordclass = 13
order by languagecode, keywordcode;

The output should be similar to the following output:

KEYWORDCLASS LANGUAGECODE KEYWORDCODE ACLNAME
------------ ------------ ----------- ----------------------------
13 ENU 0 ACL
13 ENU 1 SuperUserACL
13 ENU 2 NoAccessACL
13 ENU 3 PublicReadACL
13 ENU 4 DocRouteACL

5 record(s) selected.

Special Notices

This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a client responsibility and depends upon the client's ability to evaluate and integrate them into the client's operational environment.

Profile

Publish Date
20 January 2005


Rating: Not yet rated


Author(s)

IBM Form Number
TIPS0521