| FRM 10256 [message #393304] |
Sat, 21 March 2009 04:31  |
charuamit
Messages: 121
Registered: January 2009
|
Senior Member |
|
|
Hi all
I get an error frm 10256 when i run a form with a secure menu...can u please tell me how to overcome it step by step....I will tell you what exactly i have done :
1. Created users,roles,granted prvileges to the roles and then assigned these roles to the users at BACKEND.
2. In my menu, i specified the role name for each menu item.
When i compile and run the form with the menu attcahed,i get FRM 10256.
I am using 10g.
Please help me out.
thanks in advance.
Charu
|
|
|
|
|
|
| Re: FRM 10256 [message #393354 is a reply to message #393327] |
Sat, 21 March 2009 21:49  |
charuamit
Messages: 121
Registered: January 2009
|
Senior Member |
|
|
Hi Littlefoot
I solved the problem...........there is a file called 'forms90sec.sql'.......u have to execute it before you can run menu security via roles...
But now my boss does not want roles,users etc to be created at backend....as it will take up database space....She wants everything to be done at form level...
She wants a module which will :
1. Schema
2. Modules
3. Forms
In brief she wants a general security module through ehich you select which schema you want to secure,accordingly all modules and forms for that system will be displayed and then you can grant privileges to the various users.
I dont have any idea of how to do that ....
Any suggestions?
Thanks in advance.
Charu
|
|
|
|
| Re: FRM 10256 [message #393410 is a reply to message #393354] |
Sun, 22 March 2009 12:35 |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I disagree with your boss.
Why would you reinvent the wheel? Users, roles, privileges - security itself - has been designed by Oracle and all you need to do is to apply it.
As far as I can tell, no "space" (actually, just a little bit of it) will be consumed. Data should be kept in one schema - owners schema. All other users will only use these data, will have synonyms (which do not consume space), use views (which are stored queries and also do not consume space), etc.
Therefore, I believe that there's no need to create your own "security model".
|
|
|
|
| Re: FRM 10256 [message #393458 is a reply to message #393410] |
Sun, 22 March 2009 23:51 |
charuamit
Messages: 121
Registered: January 2009
|
Senior Member |
|
|
I agree with you...bt some how i m not able to convince her....
What she wants is :
1. The Login form :when the user enters his user name and password, his staff id is extracted from this data..
2. After the Login form , another form opens that has the full menu and sub menus....Now based on the staff id,some menu items will be enabled/disabled.
At backend we have a table for form details : form_id,form_code ( frm 1001,etc..where 1 is the module id and last 1 is the form id,1002 etc)
Another table is for module details ..
And important one is the table for Staff privileges where we store the staff id , form id and various privileges (view/write/full_control etc)....
So i am trying to write the code below in when_new_form_instance of main form :
DECLARE
PRV_VIEW CHAR(1);
FRM_CODE VARCHAR2(30);
mid MenuItem;
CURSOR C2 IS
SELECT PRV_VIEW,FORM_CODE FROM STAFF_PRIV,HR_FORMS_DETAILS
WHERE HR_FORMS_DETAILS.FORM_ID=STAFF_PRIV.FORM_ID
AND STAFF_PRIV.FORM_STAFF_ID=:GLOBAL.ST_ID;
X2 C2%ROWTYPE;
BEGIN
FOR X2 IN C2 LOOP
PRV_VIEW:=X2.PRV_VIEW;
FRM_CODE:=X2.FORM_CODE;
mid := Find_Menu_Item('FRM_CODE');
IF PRV_VIEW='N' THEN
set_menu_item_propertymid,ENABLED,PROPERTY_FALSE);
END IF;
EXIT WHEN C2%NOTFOUND;
NEXT_RECORD;
END LOOP;
EXCEPTION
WHEN OTHERS THEN
MESSAGE(SQLERRM || SQLCODE);
END;
This is just a rough idea....the code is not running....
I am working on it but any of your suggestions will be really appreciated....
And one more thing, in the menu we have renamed the menu items as FRM1011,FRM1002,ETC
Thanks in anticaption.
Charu.
|
|
|
|
|
|
| Re: FRM 10256 [message #394978 is a reply to message #394935] |
Mon, 30 March 2009 23:29 |
charuamit
Messages: 121
Registered: January 2009
|
Senior Member |
|
|
yaah i did it her way..... i implemented menu security at form level without creating any roles/users at backend....
Right now it is dome for only prvilege view.... I mean once the user signs in....he won be able to see the forms to which privilege is "NO" in the menu....
I am working on other privileges
Thanks And Regards.
Charu.
|
|
|
|
| Re: FRM 10256 [message #398759 is a reply to message #393354] |
Fri, 17 April 2009 07:57 |
robajohnson
Messages: 9
Registered: February 2006
Location: Dallas Texas area
|
Junior Member |
|
|
| Quote: | I solved the problem...........there is a file called 'forms90sec.sql'.......
|
So where did you find this script? I have searched the database server, the forms server and the the oracle client directory for forms*.sql and found nothing.
|
|
|
|
|
|
| Re: FRM 10256 [message #477969 is a reply to message #394935] |
Tue, 05 October 2010 07:46 |
k_vivek_007
Messages: 2
Registered: September 2010
Location: India
|
Junior Member |
|
|
Me too getting the same error when i try to run the form on the web
FRM-10256: User is not authorized to run Form Builder Menu
I am using 6i
in the below conversation there is a called 'forms90sec.sql'.......
what kinda file will be there for 6i
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: FRM 10256 [message #493846 is a reply to message #493798] |
Thu, 10 February 2011 03:44 |
 |
ccchan
Messages: 4
Registered: February 2011
|
Junior Member |
|
|
I also think it is the correct file, but it still does not work after I executed FRMSEC.SQL and FRMGRNT.SQL.
The ..\forms\ folder also have FDEVBILD.SQL & FDEVGRNT.SQL. I interpreted them as DEVeloper BuILD file and DEVeloper GRaNT file which may also be necessary. The codes in FDEVBILD.SQL executes ..\tools\dbtab60\TU60BILD.SQL which again, does not exists. [There is no such folder dbtab60].
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
