Re: Anyone using Infomaker?

Hi

I have used Infomaker before and you do not have to use the SYSTEM id for connecting you can set up other users also using the create database profile option within infomaker. This is a powerbuilder tool so the profiles created through powerbuilder should be accessible through Infomaker.

There are resource tables to be created before you create a profile. I think they are pb_catcol , pb_catedit, pb_catfont There is a script somewhere and you must run this first before you create those profiles.
Hope this helps. I no longer use Infomaker so i dont rememeber so well.

Sanjay Mathew
Oracle DBA
Lucent Technologies

Nick Parsons wrote:

> Hi,
> I wonder if anyone can help me.
>
> I've recently created a database on a UNIX box to replace one on an NT
> box. The users have Infomaker 5.0 as a reporting tool. They used this
> quite successfully on the NT box, mainly because the db users were all
> set up with DBA privs!
>
> I want to avoid this but can only get the connect profile to work if I
> use the SYSTEM id and password. I'm reluctant to do this as it gives
> them access to all objects. The documentation states that the connecting
> id should have Create Table and grant permissions to PUBLIC, but Connect
> and Resource gives them Create privs anyway.
>
> There are three schemas set up. What I want to do is set it up so that
> when they go into Infomaker they only see the objects within that
> particular schema.
>
> Any ideas? If you could e:mail me back I would appreciate it.
>
> TIA
>
> Nick Parsons
Received on Tue Feb 24 1998 - 00:00:00 CST