Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    San Mateo, Rizal, Philippines
    Posts
    18

    Question Unanswered: How to an object priviledge ?

    I just created 2 users named user1 and user2 with tableA and TableB respectively at Oracle enterprise manager in standalone mode using system/manager - normal mode.

    How will I grant select,delete a table object priviledge from user1 to user2 using enterprise manager?

    Scenario:

    a) create a role named ROLE_USER1, under object priviledge tab, I selected
    tableA of user1 with SELECT and DELETE priviledge. When I tried to press the apply button. Insufficient priviledge appears. Can anyone help in procedures? Even in the SqLplus, same error occurs.

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    You can only grant privilleges on an object when you are logged on as the owner of that object.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Dec 2003
    Location
    San Mateo, Rizal, Philippines
    Posts
    18

    Re:

    Do you know the SQL for granting object priviledge in Oracle 9i.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Do you know the SQL for granting object priviledge in Oracle 9i?
    Yes, I do.
    It appears it is past time for you to RTFM & learn how to do so too.
    http://download-west.oracle.com/docs...2a.htm#2062195
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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