topic Re: Securing data access across clients in Application Development and Automation Discussions

Securing data access across clients

Former Member — Fri, 17 Dec 2004 11:27:12 GMT

Hi,

Is there any way by which data can be secured against CLIENT SPECIFIED SELECT.

There are 2 clients in the same server one is production and other is development. Now I want certain data to be secured from being selected using the CLIENT SPECIFIED clause of SELECT statement.

Anyone has any idea about how to achieve this?

Regards,

Satya

Re: Securing data access across clients

Former Member — Fri, 17 Dec 2004 13:17:38 GMT

Hi Satya,

I don't know what you mean by development and production in one system. This sounds like it's not a real development system as e.g. programs are client independent and thus any program changes would be immediately visible in production (same problem for client independent customizing).

If people can create programs in your "development" system, then there's no way to prevent the CLIENT SPECIFIED selection. To secure database access, one has to explicitly add authorization checks to the program.

Best wishes, harald

Re: Securing data access across clients

ChristianFi — Tue, 21 Dec 2004 14:39:57 GMT

This would not be my biggest concern...

How do you ensure stability on your production client. If someone is changing (or even worse deleting) a program it will effect both clients.

How do you deal with that?

just my 2cts

Christian