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

Comments

sql_guy

+1

 

 

Granting DB_DDLAdmin automatically provides alter any schema and create\drop any table. The following are not necessary

- Grant create and drop table privileges for the database to the user account.
- Ensure that the user is the owner of their default schema.

Wednesday 29 December 2010, 11:59

Please login to post comments or replies.