What are the required database account permissions for Cognos content store?
SQL Server
- Grant create and drop table privileges for the database to the user account.
- Ensure that the user account is a member of the db_ddladmin, db_datareader, and db_datawriter roles.
- Ensure that the user is the owner of their default schema.
Oracle
- connect to the database.
- create, alter, and drop tables, triggers, views, procedures, and sequences (all permissions must be granted directly to the user account rather than to a role).
- insert, update, and delete data in the database tables
Sybase
- Grant create and drop table privileges on the database to the user account.
- Ensure that the user account has the following privileges for the database: create default, create procedure, create rule, create table, and create view.
DB2
- Grant create and drop table privileges on the database to the user account.
- Ensure that the user account has CREATETAB, CONNECT and IMPLICITSCHEMA privileges for the database.
- Ensure that the user account has USE privileges for the USER TEMPORARY tablespace and other appropriate tablespaces associated with the database.
- For Windows XP, ensure that the user account has GRANT privileges for the USER TEMPORARY tablespace.
www.cogknowhow.com