Because of the security risks, we recommend that you do not use the database administrator user for maintaining your
Silk Central database. This topic lists the database roles that can be used for specific tasks, as follows:
- Microsoft SQL Server
- If
Microsoft SQL Server is your DBMS for
Silk Central, the following database user roles/privileges are required for your
Silk Central database:
| Either:
|
Or:
|
- db_owner
- db_ddladmin
- VIEW SERVER STATE
|
- db_datareader
- db_datawriter
- db_ddladmin
- EXECUTE
- VIEW SERVER STATE
|
These roles/privileges allow creating and configuring database tables, working with a previously created database, and installing
and upgrading the software.
Note: The
Silk Central database user requires these roles/privileges. Otherwise, errors occur.
- Oracle
- If
Oracle is your DBMS for
Silk Central, set the following
Oracle database user privileges to work with
Silk Central:
- CREATE SESSION
- CREATE PROCEDURE
- CREATE SEQUENCE
- CREATE TABLE
- CREATE TRIGGER
- CREATE VIEW
Note: The
Silk Central database user requires all the preceding privileges. Otherwise, errors occur. To get all database-related analysis data in
system diagnostics, it is also recommended to assign the
SELECT_CATALOG_ROLE to your database user.
Note: The
Oracle user must have sufficient quotas to work with
Silk Central.
When setting up an
Oracle DBMS for
Silk Central, ensure that the
Oracle environment meets the following requirements:
- At least 2 GB of temporary tablespace is available.
- Sufficient disk space is available to handle the size of the temporary tablespace.