Changing schema name

[raamzs]

I have created Query subject using schema dev as
Select * from dev.dm_product

Now there is another schema cognos
A role READ (select) is created on dev and assigned to Cognos.
Cognos has only read privilege from dev schema and there is no tables created in it.
If I write  ‘Select * from dm_product ‘ in Oracle for Cognos, then it returns the same result as in dev although there is no physical table created in it.

Now I have to change the schema name for Query subject definition in FWM, I have tried ‘select * from cognos.dm_product’ but it throws an error the table does not exists.

Please give ur valuable suggestions
Regards,
raamzs

[blom0344]

You say that the schema 'cognos' has not been created. Why then does it surprise you that ‘select * from cognos.dm_product’ throws an error?

[raamzs]

The schema Cognos is created but tables are not created in it.

A role named "READ" having privilage Select ON ANY TABLE OF dev has been created and assinged to schema cognos.

In oracle when i loging as user cognos and write query
select * from dm_product(which exists in dev)
it returns proper result, altough there is no table dm_product created in cognos.

same thing i want to use in framework manager to build a query subject.

Hope i am clear
Regards,
raamzs

[halkosj]

Remember that there are no schema names in FM.  FM accesses Oracle via a datasource. So to have FM log into a different schema, then you have to use a different datasource which is set up to access the new schema.

So you need to do this:

Create a datasource in Cognos which connects to the "cognos" schema in Oracle.
Use the metadata import wizard and select the new datasource - the tree view comes up which displays all the schema names. Open up the "dev" node and the "table" node, and you should see the dm_product table. Select it and complete your import.

[raamzs]

Thanks all for help

I was able do acheive it following ways......
In Cognos Connection home page

Cognos Adminstration > Configuration > More under Actions > View Connection > More under Actions > View Signon > More > Set Properties > Signon Tab > Below Signon ......Edit the signon > Provide the new (cognos here)user id n pwd of user(schema)

Regards,
raamzs