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

Problem with updating the DB using sender JDBC Channel.

Hello,

I wil explain one scenario where i had given one user only the read access but not the write access.

I mean he can only select the data but not update or insert the data.

I am using such a type of user in my scenario of JDBC to RFC scenario.

Here i am selecting some data and updating that data using some queries.But as per the user he is not able to update the data.so the database is unable to update the data. But stilll the data is processed properly without any problem or atleast one alert regarding the updation of the data base.

Can any one help in solving this issue?

Thanks,

Soorya

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 03:06 PM

    >>But as per the user he is not able to update the data

    well if the user doesn't has update permission how will he be able to update the data,definitely he can select the data but since he won't be able to update it,the database will become inconsistent.

    sorry i m unable to get whats the issue you are facing

    Thanx

    Aamir

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Vijayashankar Konam

      Hello,

      I want to know why it is happening that without getting the response from the DB that the data is updated how the XI adapter is sending the data to the destinition.

      How to resolve the problem with out getting the exception like,

      The JDBC driver returned the following error message: 'java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]

      UPDATE permission denied on object 'AD_phone',

      database 'Personal', owner 'dbo'.'.

      For details, contact your database

      server vendor. "

      Can you please anyone revert it back ASAP.

      Thanks,

      Soorya

  • Posted on Jan 29, 2008 at 03:07 PM

    Hi,

    If the mentioned USER is used in the Adapter it has to throw error in Adapter montoring as No Authorization to Update the records.. What is the Database ? Did you changed the Previlage to the user recently....

    Regards

    Agasthuri Doss

    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.