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
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.
Yep, pretty much what MFGF said.
You need add, drop and alter table priviledge.
With Oracle, you'll need connect ;) resource is helpful too
Would be also nice if you've asked for help, instead of demanding an IMMEDIATE answer ... :-\