| Problem with ROLE... [message #82205] |
Wed, 07 May 2003 00:55 |
Robin ( Bangladesh)
Messages: 25
Registered: September 2002
|
Junior Member |
|
|
Experts,
Suppose user AA have DBA privilegs. User AA created role named 'Operator' with select,update,insert,create session privilegesv on a table 'invoice_m' and without password.
Then role 'Operator' is granted to new user BB. Form for data entry is ceated by form wizard (Developer 2000). In Save button only code is 'COMMIT'. When connecting as user AA form is working well, but when connecting as BB and pressing Save button, Error message 'ORA-04043: object INVOICE_M does not exist'.
May be the the resion, form generated by Developer2000's Wizard can generate INSERT command autometically when get a COMMIT. here I can't write Insert commad like INSERT INTO aa.invoicE_m.....
Pls give me a solusion.
Thanks in advance.
Robin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
