Home » Developer & Programmer » Forms » priviliges assign (Form)
priviliges assign [message #441862] Wed, 03 February 2010 09:13 Go to next message
shahzad-ul-hasan
Messages: 464
Registered: August 2002
Senior Member
i have user which have DBA rights.
SQL> SHOW USER
USER IS "BARCODE"
SQL> CREATE USER A IDENTIFIED BY A;
USER CREATED.
SQL> CREATE SYNONYM EMPLOYEE FOR EMP;
SYNONYM CREATED.
SQL> GRANT CREATE SESSION TO A;
SQL> GRANT SELECT ON EMPLOYEE TO A;
when i connect the main form with user a is connected. and it will shows me the next screen. then when i want to click on emp button. the form opened and give me error:
FRM-40505: oracle error: unable to perform query.
pls help me.
Re: priviliges assign [message #441864 is a reply to message #441862] Wed, 03 February 2010 09:33 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
It's not a permissions problem, it's a synonym problem.
You created the synonym under the barcode user rather than the a user.
The synonym needs to be in a's schema (or public) for it to be any use to them.

And when you get
FRM-40505: oracle error: unable to perform query
You should use the display error option on the menu to see exactly what the problem is.
Re: priviliges assign [message #442221 is a reply to message #441862] Fri, 05 February 2010 07:15 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 464
Registered: August 2002
Senior Member
i have created a synonym in the user in that position:
Barcode----->User-A---->Synonym Created.
But when i checked the select statemnt log in to user-a on sql peompt. it shows me the record of barcode.emp table. but when i login to form(User-A). the emp table is showing nothing.
it gives me error.:
unable to perform query....
pls advised.
Re: priviliges assign [message #442228 is a reply to message #441864] Fri, 05 February 2010 08:15 Go to previous message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
cookiemonster wrote on Wed, 03 February 2010 15:33

And when you get
FRM-40505: oracle error: unable to perform query
You should use the display error option on the menu to see exactly what the problem is.

Previous Topic: Tree node icons
Next Topic: How to Use CheckBox Is Checked All In Block by button
Goto Forum:
  


Current Time: Sun Dec 04 04:24:02 CST 2016

Total time taken to generate the page: 0.11485 seconds