Using the sample Demo Schema "SCOTT" is not recommended. Practically everyone in the Oracle world knows what the password to the SCOTT schema is.
One option would be to use a CONTEXT setting that defines the default schema for your users. This allows you to use individual database accounts (for access countrol) and point all of those accounts to a specific (default) schema.
Another option (not a good one) would be to explicitly reference the SCOTT schema in all of your code. This option requires you to add "SCOTT." to every database object reference. Like I said, this is not a good option, but it is an option.
Its seems to be that i wasnt clear enough .
In forms 11g , there is a file named : formsweb.cfg
At this file i have the following entry :
While devdb is the database name , xxx is the name of the schema owner , and yyy is the password of that user.
All my end users do NOT own any database objects at all.
All they have is a priviges that the owner of the schema (xxx) assigned to them.
For example they have assigned insert and select on table A at schema XXX
1) Since all my end users are externaly users (e.g OPS$ABCD....) , they cant connect to the forms11g application as external users.
What should i do in order to allow them to connect to the forms application.
2) If i will follow your first option , then user A for exmaple will became to be XXX , and have all its privileges - and its somthing that i dont what.
Please advise how i can solve this problem .