Analyst Maintenance

[Cinu8]

Hi guys,

we have a challenge maintaining Analyst publish.

does the user needs dba permissions to publish the analyst model every time ?
why it drops the schema and recreates every time ?
is that how it designed ?

than you in advance

cinu

[ericlfg]

Hi Cinu8,

The publish itself does drop the schema and recreate it, that part is as designed.  As for the level of access the user needs in order to publish, I think so long as you create a system DSN with the appropriate permissions you should be fine without giving them specific Oracle permissions?

[Rutulian]

Hi Cinu,

The reason it drops and recreates is to allow for structural changes since the last publish.  Most model structure changes necessarily lead to changes in the datastore schema, as do many changes to the publish options selected.

It shouldn't need DBA permissions though, as long as it has drop, create and run DDL permissions on its own schema that should be fine.  I think there might have been a change to a later version that dropped tables within the schema rather than the schema itself, but you would have to check this very carefully - I could have confused this with Contributor or something else.

[Cognos_World]

Maybe you might have already tried this...But just sharing some thoughts..
Instead of giving all the users the access to publish, maybe you can create a generic/system/group user account on the DB and the users can use that while doing to publish.

Regarding the schema, here is what it says Analyst user Guide.
User guide 10.1 Pg 754

To target an empty database or schema, you must have drop table and view privileges. Otherwise,
you must have Administration privileges on your database server before you can publish.

Hope this helps.

Thanks!