Question Locked

How can I add user id in the logical query

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Suppose I am an OBIEE Admin. My user id is 'Administrator' and password is 'Administrator'.

There is a user called ?sandip?. I know the user id of user which is 'sandip' but do not know the password.

I want to run the logical query of user 'sandip' from my user login (Administrator/Administrator ).

How can I add user id 'sandip' in the logical query (of user 'sandip') and run from Administrator's (my) login?

I have tried in the following way.

run the following command in the command prompt (where userid/passowrd is Administrator/Administrator).

nqcmd -d AnalyticsWeb -u Administrator -p Administrator -s q1.sql

The q1.sql contains the following logical statement.

SELECT Products.Type saw_0, Products.Brand saw_1 FROM Paint ORDER BY saw_0, saw_1;

How can I add user id 'sandip' in the above logical query so that it runs the logical query of user 'sandip' only? (Note: I do not know the password user 'sandip').

Please also let me know any other way apart from using iBot.

2 replies

by tony hopkinson

most have an impersonate feature, may need to grant it. For Sql server it would be

SetUser 'Sandip'

Search your help for
impersonate user

I'd be surprised if there isn't something similar.

This discussion is closed to new replies.