My sysadmin / DBA is not available and I have a questionaire to fill out. I know most of the answers but am uncertain about a few. I hope someone can help me. We run BaaN and Informix on a single server. We do not support any remote sites.

Question 1: Database Owner? When I run onstat-d, there is a column that is titled "owner" and listed in the column is informix. Am I looking at the correct resource for the answer to this question.

Question 2: Database user name? I think the answer is bsp. How can I confirm this?

Question 1: Yes!

Question 2: It depends - take a look in session ttdba0515m000, as bsp is the default user, you can say that this is a database user (one of many I guess)

Regs

pet

I have run this session and surprised to see there are no db users.:confused:

My sysadmin / dba has informix set up so that it is accessible only through BaaN. Now, we are considering using a report writer, ECQ. They have supplied me the questionaire and are requesting read-only access to informix.

I'm thinking that I need to create a new userid within informix but I have notes that my dba configured informix with no role seperation. What does this mean?

I don't know if there is a difference between Baan IV and ERP LN (which we use), but you can check the following file on the server (if you have access):

$BSE/lib/informix/inf_users

Usually this file is filled when you create new users in Baan or edit user settings in Baan. The first entry is the DB user name and the last entry in a line should be the DB group.

Regs

pet