Add Users to the Analysis Service via a script
Note User Management does not apply in a CAST Storage Service environment.
In order to use the Analysis Service, users must first be registered. On completion of the server-side component installation process, the user that installs the Analysis Service will be automatically registered and assigned Administrator rights (all processes are allowed).
If you need to add additional users and assign them the Administrator right, you can do so using an SQL script that updates a specific table in the CAST Analysis Service.
Microsoft SQL Server
In a Microsoft SQL Server environment, you can run the following script against the database hosting your CAST Analysis Service - modify it to suit your needs:
INSERT [V71_ANALYSIS_SERVICE].[dbo].[Usr]VALUES('JHU', 'MACHINE\JHU', 'James Hurrell', NULL, '0', '0', '1')GO Oracle Server
In a Oracle Server environment, you can run the following script against the database hosting your CAST Analysis Service - modify it to suit your needs:
INSERT V71_ANALYSIS_SERVICE.USRVALUES('JHU', 'MACHINE\JHU', 'James Hurrell', NULL, '0', '0', '1')/ Script tips
The following applies:
- Value 1 = user ID within the CAST Analysis Service - this is limited to 3 characters
- Value 2 = Windows login (this can also be in the form DOMAIN\LOGIN - limited to 30 characters
- Value 3 = User name (i.e. full name) - limited to 30 characters
- Value 4 = User password. Please enter NULL as this is not required
- Values 5 and 6 = Please set both to 0
- Value 7 = Determines Rights profile that will be assigned to the user - the default profile "Administrator" has the value 1
