If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

content store

Started by svenkat16, 26 Mar 2007 04:45:20 AM

Previous topic - Next topic

svenkat16

Hi,

Cognos is installed on my local machine as local host and I want to create and configure the content store on the client database . They had provided the user id and password with port number and connecting string, by this I amÃ,  not able create the content store on the client database. For this the user ID they provided to create content sore that should have " SYS DBA privillage".

I am using Oracle9i database, and It is the characterset for the databse is UTL-8 (AL32UTF8)

Tell me exactly what are the privillages required for that user, is "Sys DBA" privillage is required.



Tell me immediately..........

Thanks

Venkat

MFGF

Hi,

Which database are you using to host your content store?

If it's SQL Server, the database user login you use requires create and drop table privileges for the database, and should be a member of the db_ddladmin, db_datareader and db_datawriter roles.

Check the ReportNet Installation and Configuration Guide, Chapter 4 for more details.

Regards,

MF.
Meep!

CogDT

Yep, pretty much what MFGF said.

You need add, drop and alter table priviledge.

With Oracle, you'll need connect ;) resource is helpful too

COGNOiSe administrator

Would be also nice if you've asked for help, instead of demanding an IMMEDIATE answer ...   :-\