| Role based menu security [message #453835] |
Sun, 02 May 2010 02:31  |
charuamit
Messages: 121
Registered: January 2009
|
Senior Member |
|
|
hi friends
can u please direct me on step by step to create secure menu based on roles
Its very urgent
thanks and regards
Charu
|
|
|
|
|
|
| Re: Role based menu security [message #453845 is a reply to message #453835] |
Sun, 02 May 2010 06:15  |
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
|
Senior Member |
|
|
The below is one of the approach:
If you are using an Oracle Forms Menu Module you can use the built-in functionality. Create some menu related database roles, assign the roles to users and to the menu items you want in Oracle Forms.
SQL> CREATE ROLE ADM_ROLE;
SQL> CREATE ROLE USR_ROLES;
SQL> GRANT ADM_ROLE TO ADMIN
SQL> GRANT USR_ROLES TO <USERS>
Enable the role/menu security in Oracle Forms
Thanks,
Ved
[Updated on: Sun, 02 May 2010 06:25] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
