• Print |
• E-mail  |
• Bookmark

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