MicroStrategy ONE

Alter Connection Map statement

Modifies a connection map for a user in a project.

Copy 
ALTER CONNECTION 
 MAP FOR (USER "user_name" 
 | USER GROUP "group_name") 
 DBINSTANCE "dbinstance_name" 
 [DBCONNECTION "dbconnection_name"] 
 [DBLOGIN "dblogin_name"] 
 [LANGUAGE "locale_name"] 
 FOR PROJECT "project_name";

where:

  • USER "user_name" is the login name of an existing user to whom the connection map applies, of type string.

  • GROUP "group_name" is the login name of an existing user group to whom the connection map applies, of type string.

  • DBINSTANCE "dbinstance_name" is the name of an existing database instance (role) to be used for the connection map, of type string.

  • DBCONNECTION "dbconnection_name" is the name of an existing database connection to be used for the mapping, of type string.

  • DBLOGIN "dblogin_name" is the name of an existing database login to be used for the mapping, of type string.

  • LANGUAGE "locale_name" is the locale name that is associated with the project, of type string.

  • PROJECT "project_name" is the name of the project in which the connection map is to be used, of type string.

Example

Copy 
ALTER 
 CONNECTION MAP FOR USER "palcazar" DBINSTANCE "DBRole1" 
 DBCONNECTION "DBConn1" DBLOGIN "DBLogin1" ON PROJECT 
 "3-Tier Project";