-
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
-
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
-
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
-
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
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
|