Installation Note 37794: Post-migration steps required for SAS® Strategy Management
The permissions for the "SAS Demo User" (sasdemo) must be modified in the
following manner in order for that user to be able to access SAS Strategy
Management content:
1. Login to the tier that is running MySQL
2. Open a command window
3. Change to the MySQL bin directory (normally c:\mysql\bin)
4. Start the MySQL command-line:
mysql -h{HOST} -u{USERID} -p{PASSWORD}
where,
{HOST} = the host on which MySQL is running
{USERID} = the userid used to administer MySQL (default: sqladmin)
{PASSWORD} = the password associated with the above USERID
5. List the records where SAS Demo User is the USER_IDENTIFIER:
SELECT * FROM `sassdm`.`sas_user_actions` where USER_IDENTIFIER='SAS Demo User';
If NO rows are returned, no further steps are required in this
section. Continue to the next section, (SAS Strategy Management)
Modify Server and Library Names.
If there are rows returned, continue to the next step.
6. Enter the following line into the command-window:
UPDATE sassdm.sas_user_actions SET USER_IDENTIFIER = 'sasdemo' where USER_IDENTIFIER='SAS Demo User';
7. Verify that the update has been done by running the SQL code
in Step 5:
SELECT * FROM `sassdm`.`sas_user_actions` where USER_IDENTIFIER='SAS Demo User';
The above query should return "Empty set". If it does not, please
contact SAS Technical Support.
8. Type "quit <RETURN>" to exit the MySQL command-line
9. Close the Command Window
Operating System and Release Information
| SAS System | SAS Strategy Management | Microsoft® Windows® for x64 | 5.1 | | 9.2 TS2M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The SAS Demo User account must be modified in the SASSDM in order for that user to be able to access SAS Strategy Management content.
| Type: | Installation Note |
| Priority: | high |
| Date Modified: | 2009-11-16 17:36:44 |
| Date Created: | 2009-11-11 11:14:30 |