Home » Developer & Programmer » Forms » FRM 10256
FRM 10256 [message #393304] Sat, 21 March 2009 04:31 Go to next message
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 #393327 is a reply to message #393304] Sat, 21 March 2009 10:31 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
FRM-10256: User is not authorized to run Oracle Forms Menu.

Cause: You are not enrolled in Oracle Forms. You do not have SELECT permission on the Oracle Forms base tables.

Action: Notify your DBA.
Re: FRM 10256 [message #393354 is a reply to message #393327] Sat, 21 March 2009 21:49 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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 Go to previous messageGo to next message
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 #394935 is a reply to message #393458] Mon, 30 March 2009 19:15 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

If you did this work the right way, would your boss know that you had not done it her way? Is the boss new? Are you new? Who is moving first, you or her?

Just do it the right way and move onto the next problem.

David
Re: FRM 10256 [message #394978 is a reply to message #394935] Mon, 30 March 2009 23:29 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #398878 is a reply to message #398759] Sun, 19 April 2009 00:43 Go to previous messageGo to next message
charuamit
Messages: 121
Registered: January 2009
Senior Member
it is in :

C:\DevSuiteHome\tools\dbtab90\forms90\forms90sec.sql

Hope u find it Smile
Re: FRM 10256 [message #477969 is a reply to message #394935] Tue, 05 October 2010 07:46 Go to previous messageGo to next message
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 #477970 is a reply to message #477969] Tue, 05 October 2010 07:49 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"forms60...", perhaps? (I don't have 6i installation, so this is just a guess).
Re: FRM 10256 [message #477972 is a reply to message #477970] Tue, 05 October 2010 07:52 Go to previous messageGo to next message
k_vivek_007
Messages: 2
Registered: September 2010
Location: India
Junior Member
yeah i have "FORMS60"
but there is no such file with extension .sql
Re: FRM 10256 [message #488683 is a reply to message #477972] Mon, 10 January 2011 09:34 Go to previous messageGo to next message
Dcollin
Messages: 1
Registered: January 2011
Location: Canada
Junior Member
In 10g, the file you are looking for is frmsec.sql.
Re: FRM 10256 [message #493640 is a reply to message #393304] Wed, 09 February 2011 03:34 Go to previous messageGo to next message
ccchan
Messages: 4
Registered: February 2011
Junior Member
I executed the frmsec.sql and frmgrnt.sql to assign rights to the ROLES, but still got
FRM-10256: User is not authorized to run Form Builder Menu
Re: FRM 10256 [message #493641 is a reply to message #493640] Wed, 09 February 2011 03:39 Go to previous messageGo to next message
ccchan
Messages: 4
Registered: February 2011
Junior Member
I also tried to run the fdevbild.sql and fdevgrnt.sql, but it prompts files not found:
I have no directory named ..\dbtab60\ in Oracle_Home. All the ..60 directories are not found in 10g
I searched the online help in Form Builder. It asked me to run the frm90sec.sql but not found.
...Anyone help me on this?
Re: FRM 10256 [message #493644 is a reply to message #493641] Wed, 09 February 2011 03:52 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
On my computer, FRM90SEC.SQL is located in DEVELOPER_SUITE_HOME\TOOLS\DBTAB90\FORMS90 directory.
Re: FRM 10256 [message #493787 is a reply to message #493644] Wed, 09 February 2011 21:37 Go to previous messageGo to next message
ccchan
Messages: 4
Registered: February 2011
Junior Member
I use the Form Builder [32 bits] version 10.1.2.0.2. The ..\tools\ directory contains \tools\DBTAB\FORMS. In FORMS directory, there is only FRMSEC.SQL.
Re: FRM 10256 [message #493798 is a reply to message #493787] Thu, 10 February 2011 00:12 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell (after some Googling), for Forms 10g it is FRMSEC.SQL. For earlier versions, it was FRM90SEC.SQL, FRM50SEC.SQL etc. However, I can't confirm that it is entirely true.
Re: FRM 10256 [message #493846 is a reply to message #493798] Thu, 10 February 2011 03:44 Go to previous message
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].
Previous Topic: Printing Cheque
Next Topic: Problem at time of navigation
Goto Forum:
  


Current Time: Sun Dec 04 18:27:34 CST 2016

Total time taken to generate the page: 0.11438 seconds