A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
dspxguy
Participant
Posts: 156 Joined: Thu May 24, 2007 4:09 pm
Location: Simi Valley, CA
Post
by dspxguy » Fri Aug 17, 2018 10:26 am
How do I grant a user the common metadata user role from command line
Code: Select all
[root~]# ./DirectoryCommand.sh -url https://nnnnnnnnn:9080 -user xyz -password xyz -sub_list_sep ^ -usr_roles "UserDev^Common Metadata User"
------------------ Executing "assign_user_roles" command. ------------------
Error RoleId "Common Metadata User" is not a valid Suite or Product role.
Thanks
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Sun Aug 19, 2018 6:29 pm
I don't have access to DataStage today but am moved to ask whether you've consulted the syntax help for DirectoryCommand.sh.
Perhaps try the full form of the option, namely -assign_user_roles (there have been issues in the past where the short-form options do not work).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dspxguy
Participant
Posts: 156 Joined: Thu May 24, 2007 4:09 pm
Location: Simi Valley, CA
Post
by dspxguy » Mon Aug 20, 2018 2:07 pm
Code: Select all
./DirectoryCommand.sh -url https://nnnnnnnnn:9080 -user xyz -password xyz -sub_list_sep ^ -assign_user_roles "UserDev^CommonMetadataUser"
------------------ Executing "assign_user_roles" command. ------------------
Error RoleId "CommonMetadataUser" is not a valid Suite or Product role.
------------------ Executing "assign_user_roles" command. ------------------
Error RoleId "Common Metadata User" is not a valid Suite or Product role.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Aug 20, 2018 8:33 pm
Can you assign any of the suite roles? Can you assign any Suite Component roles?
It might be time to involve your official support provider.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dspxguy
Participant
Posts: 156 Joined: Thu May 24, 2007 4:09 pm
Location: Simi Valley, CA
Post
by dspxguy » Tue Aug 21, 2018 12:32 pm
Yes, I am able to assign other roles. Just struggling to get the right syntax for Common Metadata User, Common Metadata Administrator and Common Metadata Importer.
Code: Select all
./DirectoryCommand.sh -url https://nnnnnnnnn:9080 -user xyz -password xyz -sub_list_sep ^ -usr_roles "UserDev^SuiteAdmin"
------------------ Executing "assign_user_roles" command. ------------------
Role assignments - User Ids: "UserDev" Role Ids: "SuiteAdmin".
------------------------------------------------------------.
./DirectoryCommand.sh -url https://nnnnnnnnn:9080 -user xyz -password xyz -sub_list_sep ^ -usr_roles "UserDev^SuiteUser"
------------------ Executing "assign_user_roles" command. ------------------
Role assignments - User Ids: "UserDev" Role Ids: "SuiteUser".
------------------------------------------------------------.
./DirectoryCommand.sh -url https://nnnnnnnnn:9080 -user xyz -password xyz -sub_list_sep ^ -usr_roles "UserDev^DataStageAdmin"
------------------ Executing "assign_user_roles" command. ------------------
Role assignments - User Ids: "UserDev" Role Ids: "DataStageAdmin".
------------------------------------------------------------.
Thanks
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 21, 2018 9:29 pm
Clutching at straws here, but how about CMDUser, CMDImporter and CMDAdmin ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Aug 22, 2018 4:50 am
How about support?
-craig
"You can never have too many knives" -- Logan Nine Fingers
dspxguy
Participant
Posts: 156 Joined: Thu May 24, 2007 4:09 pm
Location: Simi Valley, CA
Post
by dspxguy » Fri Aug 24, 2018 7:43 am
Thanks Ray - But still no luck
qt_ky
Premium Member
Posts: 2895 Joined: Wed Aug 03, 2011 6:16 am
Location: USA
Post
by qt_ky » Mon Aug 27, 2018 4:56 am
Ray, you were really close. Here is the command output from an 11.3 server.
Code: Select all
------------------ Listing roles in ASB directory. ------------------
Role ID: "CMAdmin" Name: "Common Metadata Administrator".
Role ID: "CMImporter" Name: "Common Metadata Importer".
Role ID: "CMUser" Name: "Common Metadata User".
Role ID: "DCAuthor" Name: "DCAuthor".
Role ID: "DCUser" Name: "DCUser".
Role ID: "DQCConsoleAdmin" Name: "Data Quality Console Administrator".
Role ID: "DQCBusinessSteward" Name: "Data Quality Console Business Steward".
Role ID: "DQCReviewManager" Name: "Data Quality Console Review Manager".
Role ID: "DQCReviewer" Name: "Data Quality Console Reviewer".
Role ID: "DataStageAdmin" Name: "DataStage and QualityStage Administrator".
Role ID: "DataStageDeveloper" Name: "DataStage and QualityStage Developer".
Role ID: "DataStageOperationsViewer" Name: "DataStage and QualityStage Operations Viewer".
Role ID: "DataStageOperator" Name: "DataStage and QualityStage Operator".
Role ID: "DataStageProductionManager" Name: "DataStage and QualityStage Production Manager".
Role ID: "DataStageSuperOperator" Name: "DataStage and QualityStage Super Operator".
Role ID: "DataStageUser" Name: "DataStage and QualityStage User".
Role ID: "EMAdmin" Name: "Exception Management Administrator".
Role ID: "EMBusinessSteward" Name: "Exception Management Business Steward".
Role ID: "EMDataSteward" Name: "Exception Management Data Steward".
Role ID: "EMStewardManager" Name: "Exception Management Steward Manager".
Role ID: "FastTrackAdministrator" Name: "FastTrackAdministrator".
Role ID: "FastTrackProjectAuthor" Name: "FastTrackProjectAuthor".
Role ID: "FastTrackProjectManager" Name: "FastTrackProjectManager".
Role ID: "FastTrackProjectUser" Name: "FastTrackProjectUser".
Role ID: "FastTrackUser" Name: "FastTrackUser".
Role ID: "ISDAdministrator" Name: "ISD Administrator".
Role ID: "ISDConsumer" Name: "ISD Consumer".
Role ID: "ISDDesigner" Name: "ISD Designer".
Role ID: "ISDOperator" Name: "ISD Operator".
Role ID: "ISDProjectAdministrator" Name: "ISD Project Administrator".
Role ID: "ISDUser" Name: "ISD User".
Role ID: "SorcererBusinessAnalyst" Name: "Information Analyzer Business Analyst".
Role ID: "SorcererDataAdmin" Name: "Information Analyzer Data Administrator".
Role ID: "SorcererDataAnalyst" Name: "Information Analyzer Data Analyst".
Role ID: "SorcererOperator" Name: "Information Analyzer Data Operator".
Role ID: "SorcererDataSteward" Name: "Information Analyzer Data Steward".
Role ID: "SorcererDeveloper" Name: "Information Analyzer Developer".
Role ID: "SorcererDrilldownUser" Name: "Information Analyzer DrillDown User".
Role ID: "SorcererAdmin" Name: "Information Analyzer Project Administrator".
Role ID: "SorcererUser" Name: "Information Analyzer User".
Role ID: "GlossaryAdmin" Name: "Information Governance Catalog Glossary Administrator".
Role ID: "GlossaryAuthor" Name: "Information Governance Catalog Glossary Author".
Role ID: "GlossaryBasicUser" Name: "Information Governance Catalog Glossary Basic User".
Role ID: "MDWAdministrator" Name: "Information Governance Catalog Information Asset Administrator".
Role ID: "GlossaryAssigner" Name: "Information Governance Catalog Information Asset Assigner".
Role ID: "MDWUser" Name: "Information Governance Catalog Information Asset Author".
Role ID: "GlossaryUser" Name: "Information Governance Catalog User".
Role ID: "RulesAdministrator" Name: "Rules Administrator".
Role ID: "RulesAuthor" Name: "Rules Author".
Role ID: "RulesManager" Name: "Rules Manager".
Role ID: "RulesUser" Name: "Rules User".
Role ID: "SuiteAdmin" Name: "Suite Administrator".
Role ID: "SuiteUser" Name: "Suite User".
------------------------------------------------------------.
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Aug 27, 2018 6:02 am
People can be Sorcerers? Interesting...
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Aug 27, 2018 7:53 pm
Sorcerer was the internal project name for Information Analyzer.
Now, listen to "
Journey of the Sorcerer " (The Eagles) and see if you recognize the tune.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Aug 27, 2018 9:22 pm
HHGTTG
However, did any of that help fix the problem dspxguy is having?
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 28, 2018 2:05 am
chulett wrote: HHGTTG
However, did any of that help fix the problem dspxguy is having?
42
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
qt_ky
Premium Member
Posts: 2895 Joined: Wed Aug 03, 2011 6:16 am
Location: USA
Post
by qt_ky » Tue Aug 28, 2018 4:29 am
With that, I vote to mark this topic resolved!
Choose a job you love, and you will never have to work a day in your life. - Confucius