| priviliges assign [message #441862] |
Wed, 03 February 2010 09:13  |
shahzad-ul-hasan
Messages: 625
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  |
cookiemonster
Messages: 13938
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 |
shahzad-ul-hasan
Messages: 625
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 |
cookiemonster
Messages: 13938
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
