| ORA-01031 [message #554968] |
Sun, 20 May 2012 03:58  |
hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates
|
Senior Member |
|
|
i create table emp on train4 (im the dba)
/
grant select on emp to user1
/
grant update (deptno) on emp to user1
/
then i create forms for emp table
/
when user1 try to update deptno fields on emp forms it show this message
ORA-01031: insufficient privileges
how to solve this problem all what i need is to give user1 only priviliges to select emp table and to update deptno field on emp table only
/
|
|
|
|
| Re: ORA-01031 [message #555038 is a reply to message #554968] |
Mon, 21 May 2012 02:05  |
 |
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Open Forms Builder and navigate to data block's Property Palette. Under the "Database" section, set "Update changed columns only" property to "YES".
P.S. Note that it will enable user to update the DEPTNO item's value as he's been granted it. However, if user modifies any other item's value as well (for example, DEPTNO and JOB), update will fail again - the same insufficient privileges error. Such a behaviour can be misleading because you let users modify item's value, but it is impossible to save these changes.
Maybe you should consider disabling items (SET_ITEM_PROPERTY) that can not be modified.
[Updated on: Mon, 21 May 2012 02:08] Report message to a moderator |
|
|
|
| Re: ORA-01031 [message #555511 is a reply to message #555038] |
Thu, 24 May 2012 12:20 |
 |
nnigam
Messages: 12
Registered: May 2012
Location: Washington, DC
|
Junior Member |
|
|
|
Great suggestion Littlefoot. I have had this issue before, but never tried it this way. I will certainly give it a try next time.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
