Skip to Content
author's profile photo Former Member
Former Member

Securing data access across clients

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2004 at 01:17 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 21, 2004 at 02:39 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.