Using the smsampleusers_sqlserver.sql file installed with the Policy Server, you can configure a user store in a SQL Server database. This file is installed in the <siteminder_installation>\db\SQL directory.
Note: User stores are not limited to UTF-8 format. You can create a user store in the local character set encoding.
To configure a Japanese user store in SQL Server
Japanese example:
insert into SmUser ( UserID , Name, Password,
LastName, FirstName, ...)
values (12, N'',
'siteminder','guest','guest','guest@mycompany.com...)
Note: More information on importing the smsampleusers_sqlserver.sql file exists in Sample User Directories.
Example: the following sample query scheme statements:
select Name, 'User' from SmUser where Name = '%s' Union select Name, 'Group' from SmGroup where Name = '%s'
should become:
select Name, 'User' from SmUser where Name = N'%s' Union select Name, 'Group' from SmGroup where Name = N'%s'
The user store configuration is complete and now supports multi-byte characters.
Copyright © 2010 CA. All rights reserved. | Email CA about this topic |