Home » Developer & Programmer » Forms » table right user (table right user in oracle 10 and form 6i)
table right user [message #687713] Tue, 16 May 2023 04:31 Go to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
dear sir
i create EMP table data form with scott user
that run rightly
but when i run that form with fahim user that no give me the data and give me this error

no error-40505 unable to perform query

]error-40505 unable to perform query

see in attached file


how to other user use form for data feeding
i give the form to data entry operator for data feeding

please give me the solution
also i give all right to fahim of EMP table right


see sql command

CREATE USER fahim IDENTIFIED BY fahim;
GRANT CONNECT TO fahim;
GRANT CONNECT, RESOURCE, DBA TO fahim;
GRANT CREATE SESSION TO fahim;


GRANT  SELECT,   INSERT,  UPDATE,   DELETE  ON   emp TO   fahim;
Re: fahim [message #687714 is a reply to message #687713] Tue, 16 May 2023 05:01 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
Dear sir

when i give nave with user owner user

scott.emp then form run right with fahim user


how to user fahim directly use the EMP form for data feeding

please give me idea
regard

table right user [message #687715 is a reply to message #687713] Tue, 16 May 2023 05:06 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
Dear sir

when i given the table name with owner user name

scott.emp then form run right with fahim user


how to user fahim directly use the EMP form for data feeding

this is database right issue or form issue

i given all right to fahim user

please give me idea
regard
Re: table right user [message #687717 is a reply to message #687715] Tue, 16 May 2023 05:55 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a synonym.

Connect as FAHIM and then

SQL> create synonym emp for scott.emp;

Synonym created.

SQL>
Re: table right user [message #687720 is a reply to message #687717] Tue, 16 May 2023 07:56 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
thank you for your prompt reply

but sir if 500 table , view and procedures  then i will create 500 synonym

please give me any good solution;

waiting for your kindness favor and valuable reply

regard

Re: table right user [message #687727 is a reply to message #687720] Wed, 17 May 2023 07:52 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
What is wrong with creating 500 synonyms? In an EBS database, you have to create umpteen thousand synonyms Smile

You could try running

ALTER SESSION SET CURRENT_SCHEMA=SCOTT;

which should prepend SCOTT. to all bare object names.

Re: table right user [message #687733 is a reply to message #687727] Wed, 17 May 2023 15:02 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If user FAHIM should see all SCOTT's tables, you could write code to write code for you.

For example, connected as SCOTT run the following PL/SQL block, spool output into a .SQL script and run it when connected as FAHIM.

SQL> spool fahim.sql
SQL> set serveroutput on;
SQL> declare
  2    l_str varchar2(200);
  3  begin
  4    for cur_r in (select table_name from user_tables) loop
  5      l_str := 'create synonym ' || cur_r.table_name || ' for scott.' || cur_r.table_name ||';';
  6      dbms_output.put_line(l_str);
  7    end loop;
  8  end;
  9  /
create synonym STAFF for scott.STAFF;
create synonym TEST for scott.TEST;
create synonym HOSPITAL_WARDS for scott.HOSPITAL_WARDS;
create synonym HOSPITAL_BEDS for scott.HOSPITAL_BEDS;
create synonym MASTER for scott.MASTER;
create synonym TABLEA for scott.TABLEA;
create synonym TABLEB for scott.TABLEB;
<snip>
create synonym BUY for scott.BUY;
create synonym RENT for scott.RENT;

PL/SQL procedure successfully completed.

SQL> spool off
SQL>
(Edit FAHIM.SQL first as it contains PL/SQL block as well, and you don't need it).
Previous Topic: Hide URL call over web_show_document
Next Topic: Add custom field with custom PLL
Goto Forum:
  


Current Time: Fri Mar 29 10:36:42 CDT 2024