grant insert privileges - error insufficent privileges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: grant insert privileges - error insufficent privileges

  1. #1
    Join Date
    Nov 2001
    Posts
    110

    grant insert privileges - error insufficent privileges

    Logged into the database base as sys, then created a user A and tried to grant him insert privileges to table test which exists in schema B.

    SQL> grant insert on B.TEST to user A;

    I get the error insufficient privelages.

    So I logged into the schema b and gave the privileges to the user A, which succeded. Not sure why I could not grant the insert privileges against another schema to a user, if I am logged in as sys or system.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    because you don't have the privilege to grant privileges on other peoples objects. http://download-west.oracle.com/docs...6privs.htm#849
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2001
    Posts
    110
    Is that true even if you are logged in as SYSTEM or SYS.

    "Because you don't have the privilege to grant privileges
    on other peoples objects. "

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    did you read the link?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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