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

Thread: Insufficient privilages

  1. #1
    Join Date
    May 2003
    Location
    Bangalore , India
    Posts
    31

    Question Insufficient privilages

    Hi,

    I have an acount which can perform any DML activity to another user object. The update statement works fine when I execute the statement directly in sql prompt. But the same if I am putting in a precedure I am facing Insufficient privilage. I am using username.objectname. My oracle version is 9i and os is windows 2000

    Can any body tell we what is the issue?

    Thanks in advance.

    -Mohit.
    Mohit Sharan
    DBA
    Bangalore.
    Cell No : 91-9845211820

  2. #2
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    is there any DML statement within the procedure?
    Last edited by bhallar; 12-13-2003 at 03:13 AM.

  3. #3
    Join Date
    May 2003
    Location
    Bangalore , India
    Posts
    31
    Yes there are DML statement like Insert, Update and Delete
    Mohit Sharan
    DBA
    Bangalore.
    Cell No : 91-9845211820

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    well i bet if in sql plus if you say

    set role none

    then you will get the same error..Basically you have been granted the provileges through a role and roles are nor effective from inside a pl/sql proc..you got to have the privileges granted to you directly rather than via a role.

    regards
    Hrishy

  5. #5
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    My bad , wanted to ask DDL.

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