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

Thread: privilizes to run

  1. 05-06-2003, 03:05 PM #1
    prodadmin
    prodadmin is offline Senior Member
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    privilizes to run

    I am running the a cursor which is in 9i environment and I am getting
    insufficent privilizes error.I am trying to update a view through the cursor
    How to give privilizes so that I can run this .
    Can some one provide a command or how to do in OEM


    Pls advise
    Reply With Quote Reply With Quote
  2. 05-06-2003, 03:39 PM #2
    marcio.68
    marcio.68 is offline Carpe.Diem
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    You need grant of select and update on view. But this view do not create with "WITH READ ONLY" option and view need grant select and update on tables.
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br
    Reply With Quote Reply With Quote
  3. 05-06-2003, 03:55 PM #3
    prodadmin
    prodadmin is offline Senior Member
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    after giving a role ,I am getting a different error

    "data manipulation operation not legal on this view"

    what exactly means this and how make this view updatble
    can some provide me a query pls

    thanks in advance for the help
    Reply With Quote Reply With Quote
  4. 05-06-2003, 04:37 PM #4
    Partha
    Partha is offline Junior Member
    Join Date
    May 2003
    Location
    hyderabad, India
    Posts
    10
    If the view definition is based on a group function on one or more columns of the base table, then this kind of complex views are not updateable directly. We have to implement instead of trigger for this purpose.

    I hope this solves ur problem. Do revert back for any other queries.

    Tks

    Partha
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width