security on form [message #244870] |
Thu, 14 June 2007 07:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hany_marawan
Messages: 198 Registered: April 2005 Location: Cairo - Egypt
|
Senior Member |
|
|
Hello
I built a customized form and put it in the application.
I want giving an different authorities to the use, i.e someone can enter data only the other can query only the third can update only..etc.
How can I do this.
Thanks
|
|
|
Re: security on form [message #244902 is a reply to message #244870] |
Thu, 14 June 2007 09:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21813 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
By granting required privileges on the table, such as
GRANT SELECT ON form_table TO scott;
GRANT INSERT ON form_table TO mike;
GRANT UPDATE ON form_table TO jenny;
|
|
|