Home » Developer & Programmer » Forms » FRM-41072
FRM-41072 [message #83694] Sat, 29 November 2003 10:53 Go to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Lately, i migrated my data from a Database Server 7.3.3 to a 9.2.0.1 one.

The problem now is that my forms work well if the server is the Oracle 7 but not if the Server is 9.2.0.1

While i am on the Oracle Database Servewr 9i R2
The forms work good if the user who logs in is the database owner. I can create a user through the application that puts under it's schemes the required Synonyms.

But when i log on as an application user i receive the following error

"FRM-41072: Cannot create group CGDV$DLRG"
"FRM-41076: Error populating Group"
"FRM-41075: Error Deleting Group"

By pressing ok i can execute the queries.

But the error messages are annoying.

Do you know how to fix the problem?
Re: FRM-41072 [message #83697 is a reply to message #83694] Mon, 01 December 2003 07:09 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
you have problem with grants.
some sys/system procedure/functions needs to be granted directly to user and not by synonyms.
Previous Topic: Block Creattion based on Stored Procedure
Next Topic: can i get the sql scripts when running a form?
Goto Forum:
  


Current Time: Sat Apr 20 04:31:33 CDT 2024