对Cognos自带内容库derby的操作

字数 4132阅读 2794评论 0赞 0

原帖： http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.inst_cr_winux.8.4.0.doc/inst_cr_winux_id16710ChangeDefaultUserandPasswordforCog.html

IBM® Cognos® 8 Business Intelligence Installation and Configuration Guide 8.4.0
Configuration Options > Changing Default Configuration Settings >

Change Default User and Password for Cognos Content Database

If you install Cognos Content Database, the default database that is created is given a user ID and password. We recommend that you change this user ID and password.

Administration tasks for Cognos Content Database are performed using a utility named ij. For information about this utility, see the Apache Derby documentation. The documentation is available in the c8_locationderby10.1.2.1docs directory where you installed Cognos Content Database.

Steps to Change the Default User Password

1.On the computer where you installed Cognos Content Database, go to thec8_locationderby10.1.2.1bin directory.
2.Start the ij utility using the ij.bat or ij.ksh script file.
The ij utility is a command line utility for creating and managing Cognos Content Database.
3.Connect to the default database by typing the following ij utility command:
connect 'jdbc:derby://localhost:1527/cm;user=cognos;password=cognos';
If you changed the port number from the default 1527, use the correct port number for your Cognos Content Database.
The default database is named cm. The database name is case sensitive.
4.Change the default password for the cognos user by typing the following ij utility command:
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.cognos', 'NewPassword');
The new password must be used for the next connection to the database.
5.Close the ij utility by typing the following command:
disconnect;

Steps to Create a New User and Password

1.On the computer where you installed Cognos Content Database, go to thec8_locationderby10.1.2.1bin directory.
2.Start the ij utility using the ij.bat or ij.ksh script file.
3.Connect to the default database by typing the following ij utility command:
connect 'jdbc:derby://localhost:1527/cm;user=cognos;password=cognos';
If you changed the port number from the default 1527, use the correct port number for your Cognos Content Database.
The default database is named cm. The database name is case sensitive.
4.Create a new user by typing the following ij utility command:
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.NewUser', 'NewUserPassword');
5.Give the new user full access to the database by typing the following ij utility command:
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.database.fullAccessUsers’,’cognos, NewUser');
The property that you are changing, the list of users, is a comma-delimited field. In this step, you are including the new user in the list of users with full access. The default user, cognos, is still part of the list of users with full access. You can remove the cognos user.
6.Close the ij utility by typing the following command:
disconnect;

Steps to Remove a User

1.On the computer where you installed Cognos Content Database, go to thec8_locationderby10.1.2.1bin directory.
2.Start the ij utility using the ij.bat or ij.ksh script file.
3.Connect to the default database by typing the following ij utility command:
connect 'jdbc:derby://localhost:1527/cm;user=NewUser; password=NewUserPassword';
4.Choose the kind of user that you want to remove:
- To remove a user from the list of users with full access, type the following ij utility command:
  CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.database.fullAccessUsers', 'NewUser');
  You omit the user name from the list of users with full access. For example, the above command removes the default cognos user and keeps the new user that you just created.
- To remove a user from the database, type the following ij utility command and omit the user password:
  CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.cognos', '');
  This command removes the password for the default cognos user, which also removes the user from the database.
5.Close the ij utility by typing the following command:
disconnect;

商业智能

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

对Cognos自带内容库derby的操作

添加新评论0 条评论

作者其他文章

相关问题

相关资料