Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Infomaker Update

4 posts in PB Infomaker Report Writer Last posting was on 1998-08-06 16:25:08.0Z
Nick Simino Posted on 1998-08-05 13:30:18.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 05 Aug 1998 08:30:18 -0500
From: Nick Simino <nicks@mindless.com>
X-Mailer: Mozilla 4.03 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Infomaker Update
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 15
Message-ID: <348_35C85E6A.E1C3EE8D@mindless.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:4893
Article PK: 243722

I have a Sybase 11 database with a PowerBuilder app and a PowerJ app
that I use to view/update data. Some users will also have Infomaker and
we would like to be able to give update rights to groups of users and
control what they can update with the PB and PowerJ apps. The problem
is that if they use Infomaker we can't control what they see.

Is there a way to install Infomaker without giving users the ability to
update data? Or is there a way to tell the database that it is
Infomaker accessing it and revoke update permissions for that session?

Nick


Terry Dykstra [TeamPS] Posted on 1998-08-05 18:08:08.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Infomaker Update
Date: Wed, 5 Aug 1998 12:08:08 -0600
Lines: 33
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_9t56PJJw9GA.261@forums.powersoft.com>
References: <348_35C85E6A.E1C3EE8D@mindless.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:4892
Article PK: 243720

You can install IM with the write capability disabled, i.e. no forms,
pipeline, database painters enabled.
You can also set in the dbparm for the Tablecriteria what the user will see,
i.e. tables, views, synonyms. This will not prevent them from accessing
other tables if they happen to know the names, but it makes it more
difficult.
The best would be to assign roles in the database to set the security. I'mm
not familiar with Sybase, but I imagine it has something similar to Oracle.
We assign default roles that allow only read access to tables. Users will
have update roles too, but those are password protected and are not enabled
by default. Within the PB / VB applications we enable those roles when a
user logs on.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
See you at the Powersoft Conference in L.A.
http://www.sybase.com/Events/psuc98/index.html

Nick Simino wrote in message <35C85E6A.E1C3EE8D@mindless.com>...
>I have a Sybase 11 database with a PowerBuilder app and a PowerJ app
>that I use to view/update data. Some users will also have Infomaker and
>we would like to be able to give update rights to groups of users and
>control what they can update with the PB and PowerJ apps. The problem
>is that if they use Infomaker we can't control what they see.
>
>Is there a way to install Infomaker without giving users the ability to
>update data? Or is there a way to tell the database that it is
>Infomaker accessing it and revoke update permissions for that session?
>
>Nick


Nick Simino Posted on 1998-08-05 18:16:36.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 05 Aug 1998 13:16:36 -0500
From: Nick Simino <nicks@mindless.com>
X-Mailer: Mozilla 4.03 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Re: Infomaker Update
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 50
Message-ID: <348_35C8A184.EA601290@mindless.com>
References: <348_35C85E6A.E1C3EE8D@mindless.com> <348_9t56PJJw9GA.261@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6959
Article PK: 242991

We thought about granting update to the user when they log on to the PB
app but there is a loophole there that if the user opens infomaker while
they are logged on to the PB app then they have update ability. Or if
the PB app GPFs (not that this could ever happen in a microsoft
environment) how are the roles revoked?


Nick

Terry Dykstra [TeamPS] wrote:
>
> You can install IM with the write capability disabled, i.e. no forms,
> pipeline, database painters enabled.
> You can also set in the dbparm for the Tablecriteria what the user will see,
> i.e. tables, views, synonyms. This will not prevent them from accessing
> other tables if they happen to know the names, but it makes it more
> difficult.
> The best would be to assign roles in the database to set the security. I'mm
> not familiar with Sybase, but I imagine it has something similar to Oracle.
> We assign default roles that allow only read access to tables. Users will
> have update roles too, but those are password protected and are not enabled
> by default. Within the PB / VB applications we enable those roles when a
> user logs on.
>
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
> See you at the Powersoft Conference in L.A.
> http://www.sybase.com/Events/psuc98/index.html
>
> Nick Simino wrote in message <35C85E6A.E1C3EE8D@mindless.com>...
> >I have a Sybase 11 database with a PowerBuilder app and a PowerJ app
> >that I use to view/update data. Some users will also have Infomaker and
> >we would like to be able to give update rights to groups of users and
> >control what they can update with the PB and PowerJ apps. The problem
> >is that if they use Infomaker we can't control what they see.
> >
> >Is there a way to install Infomaker without giving users the ability to
> >update data? Or is there a way to tell the database that it is
> >Infomaker accessing it and revoke update permissions for that session?
> >
> >Nick


Terry Dykstra [TeamPS] Posted on 1998-08-06 16:25:08.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Infomaker Update
Date: Thu, 6 Aug 1998 10:25:08 -0600
Lines: 60
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_$krRV0Uw9GA.189@forums.powersoft.com>
References: <348_35C85E6A.E1C3EE8D@mindless.com> <348_9t56PJJw9GA.261@forums.powersoft.com> <348_35C8A184.EA601290@mindless.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6958
Article PK: 242987

The update capability should be assigned to the role, not directly to the
user. Since the role gets enabled for a specific PB session, an IM session
would not have this capability.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
See you at the Powersoft Conference in L.A.
http://www.sybase.com/Events/psuc98/index.html

Nick Simino wrote in message <35C8A184.EA601290@mindless.com>...
>We thought about granting update to the user when they log on to the PB
>app but there is a loophole there that if the user opens infomaker while
>they are logged on to the PB app then they have update ability. Or if
>the PB app GPFs (not that this could ever happen in a microsoft
>environment) how are the roles revoked?
>
>
>Nick
>
>Terry Dykstra [TeamPS] wrote:
>>
>> You can install IM with the write capability disabled, i.e. no forms,
>> pipeline, database painters enabled.
>> You can also set in the dbparm for the Tablecriteria what the user will
see,
>> i.e. tables, views, synonyms. This will not prevent them from accessing
>> other tables if they happen to know the names, but it makes it more
>> difficult.
>> The best would be to assign roles in the database to set the security.
I'mm
>> not familiar with Sybase, but I imagine it has something similar to
Oracle.
>> We assign default roles that allow only read access to tables. Users
will
>> have update roles too, but those are password protected and are not
enabled
>> by default. Within the PB / VB applications we enable those roles when a
>> user logs on.
>>
>> --
>> Terry Dykstra [TeamPS]
>> Canadian Forest Oil Ltd.
>> See you at the Powersoft Conference in L.A.
>> http://www.sybase.com/Events/psuc98/index.html
>>
>> Nick Simino wrote in message <35C85E6A.E1C3EE8D@mindless.com>...
>> >I have a Sybase 11 database with a PowerBuilder app and a PowerJ app
>> >that I use to view/update data. Some users will also have Infomaker and
>> >we would like to be able to give update rights to groups of users and
>> >control what they can update with the PB and PowerJ apps. The problem
>> >is that if they use Infomaker we can't control what they see.
>> >
>> >Is there a way to install Infomaker without giving users the ability to
>> >update data? Or is there a way to tell the database that it is
>> >Infomaker accessing it and revoke update permissions for that session?
>> >
>> >Nick