Role problem !! Help. [message #42746] |
Tue, 06 May 2003 01:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Robin
Messages: 73 Registered: October 2001
|
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'.
Pls give me a solusion.
Thanks in advance.
Robin
|
|
|
|
Re: Role problem !! Help. [message #42759 is a reply to message #42747] |
Wed, 07 May 2003 00:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Robin
Messages: 73 Registered: October 2001
|
Member |
|
|
hi Barbara Boehmer,
thanks for helping me. Actually, If I can write command like 'Insert into aa.InvoicE_m (inv_id,Entry_dt) values (1,sysdate)' Its working fine. But, u know, when a form is developed by wizard of Developer2000 one 'Commit' command autometically generate Insert command where I can not add like aa.invoice..... Is there any way to do this ?
Thanks
Robin
|
|
|