SRV - User privileges and server requirements for server-side installation

In a CAST Storage Service environment, it is not necessary to manage user privileges. The pre-prepared "operator" login must be used when installing CAST components.

1. You must make sure that you use a supported Client/Server API that it is correctly installed on your client PC. Otherwise, you cannot connect to your server with CAST products.
2. CAST Server Manager uses two specific connections. The first is the connection you define when you first launch CAST Server Manager (see Launch Server Manager) - this grants access to the server and you typically need to use the system user or a user with DBA equivalent privileges (see Connection for more information).

   The second is a connection that uses the user name associated to the schema you are attempting to install components on or the user name created by Server Manager before the creation of a new schema. In this case the privileges granted to the user name will be used.

   Some specific operations require specific privileges as listed below:

   Installation Operation	Required Privileges
   New schema installation (creation of a new schema on the server for CAST) and Schema uninstall (removal of a schema created on the server for CAST)	CREATE_USER ALTER_USER GRANT_ANY_PRIVILEGE GRANT_ANY_ROLE SELECT_ANY_DICTIONARY

3. All other operations (installation/removal of components etc...) are carried out using the user name associated to the schema you are attempting to install the components on. In this case the privileges granted to the user name will be used.
   
   If you have created a schema specifically for CAST components then a user will also have been created. This user and its privileges will be used by Server Manager to install the components.

Notes

• Please note that these database user privileges MUST be granted directly to the user and NOT via the use of a role. For example, if you grant these privileges to a role, and then grant that role to the user, CAST Applications may not work properly.

1. You must make sure that you use a supported Client/Server API that it is correctly installed on your client PC. Otherwise, you cannot connect to your server with CAST products.
2. To install the CAST Server Side components, please make sure that your database login has the following privileges:
   • login with the "sysadmin" role (System Administrator)