Securing data access across clients

[Former Member]

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

[Former Member]

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

[ChristianFi]

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