Assign role from command line

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

Assign role from command line

Post by dspxguy »

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 »

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 »

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 »

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 »

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 »

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
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

How about support? :wink:
-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 »

Thanks Ray - But still no luck
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

When in doubt, try searching the documentation.

Here is the support portal URL (as of today):

https://www.ibm.com/mysupport/s/?language=en_US

A quick search there reveals a useful technote:

https://www-01.ibm.com/support/docview. ... wg21625366

And it says:

Be sure to put the correct value for the role you wish to set. To see all valid values run:

Code: Select all

DirectoryCommand.sh -list ROLES
Choose a job you love, and you will never have to work a day in your life. - Confucius
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

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
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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 »

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
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

HHGTTG 8)

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 »

chulett wrote:HHGTTG 8)

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
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

With that, I vote to mark this topic resolved! :lol:
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply