| Failed to implement menu security in forms 6i ! Someone help plzzzzzz. [message #84810] |
Thu, 29 April 2004 02:14  |
mehbub
Messages: 7
Registered: December 2003
|
Junior Member |
|
|
Hello....
I am trying to implement the menu security scheme but faild.Can any one plzzz help me ? The steps I followed are...
1.Created a role 'b' as a user 'a' (User 'a' is granted the dba role).
2.Created tables as the user 'a' and created forms on those tables.
3. Created a menu and specified the role 'b' in the "module roles" property.Set the "use security" property to yes.
4.Specified the role 'b' in the 'item roles' property for all the menu items.
5.Attached the menu with the forms.
Now when I try to run the forms as the user 'a' ,I get the error... FRM-10256: User is not authorized to run Form Builder Menu.
I found in the "forms help", that, the reason for this error is user is not granted privileges on the forms tables. But I created all the tables as the user 'a'.Again ,when I set the 'use security' property to false for the menu then I can run the forms and can query ,update to the database.So there should not be any question of privilege to the tables, I think. I also created the role 'b' as the user 'a' , so the user 'a' is having full control over the role 'b'. So I am really undone in this regard and find no way to overcome. Can anyone plzzzz describe the steps to implement menu security and tell me ...where is the error ? Someone plzzzz help.
Many many thanks in advance.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
