How to deal with user name in impromptu

[dm21]

I am trying to get a database user name in impromptu.

I am using sybase as a database. In sybase if try to get name using user_name() or suser_name()function, I get different value.

I am using a physical table to report from, where I insert records through stored procedure. Now I want to handle the deletion of records for more than one user accessing this report. I was thinking of doing that by passing database user id.

Is there is any other way to handle this?

 

[dm21]

Hi

I know now what was the problem. In my database configuration the database name was looking at Master instead of the one I am using.