During vCenter Single Sign-On installation, if you are using an IBM DB2 database and you have created users manually with the rsaIMSLiteDB2SetupUsers.sql script, you might receive an error that the database users do not have sufficient privileges.

When you install vCenter Single Sign-On and the installer requests Single Sign-On database information for existing databases, you have the option to select the Use manually created DB users check box. The insufficient privilieges error can occur during Single Sign-On installation if you use an IBM DB2 database and you have created users manually with the rsaIMSLiteDB2SetupUsers.sql script.

The rsaIMSLiteDB2SetupUsers.sql script does not include two required privileges.

1

Open the rsaIMSLiteDB2SetupUsers.sql script with a text editor.

The script is located in the directory vCenter Server installation directory\Single Sign On\DBScripts\SSOServer\schema\db2.

2

Edit the script to include the following privileges:

GRANT DBADM ON DATABASE TO USER RSA_DBA;
GRANT CREATETAB ON DATABASE TO USER RSA_USER;
3

Run the script and retry the Single Sign-On installation.