MicroStrategy ONE

Alter DBLogin statement

Modifies the properties of a DBLogin.

Copy
ALTER DBLOGIN 
 "dblogin_name"[NAME "new_dblogin_name"] 
 [LOGIN "new_database_login"] 
 [PASSWORD "new_database_password"];

where:

  • DBLOGIN "dblogin_name" is the name of the database login to be modified, of type string.

  • NAME "new_dblogin_name" is the new name of the database login, of type string.

  • LOGIN "new_database_login" is the database user to be used by the database login, of type string.

  • PASSWORD "new_database_password" is the database password to be used by the database login, of type string.

Example

Copy
ALTER DBLOGIN "DbLogin1" LOGIN "dbadmin PASSWORD dbadmin1;