DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Insufficient privileges

  1. #1
    Join Date
    Nov 2000
    Posts
    1
    Apologies in advance; this is my first post.

    We have a trigger on a delete that invokes a Java stored procedure (JSP). That uses jdbc to do "select mysequence.nextval from dual", and I get an insufficent privileges error.

    Any ideas?

  2. #2
    Join Date
    May 2000
    Location
    Richardson, Texas, USA
    Posts
    39
    Make sure that the user has privilege on mysequence (you can test that from sqlplus by running that select statement, but remember that it'll increase the value of the sequence by one). In case there is no privilege problem with the sequence then you may try granting the JAVAUSERPRIV to the user from the system account.

    Thanks.

    Syed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width