OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Can I build an application using a table which is owned by another user?

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Can I build an application using a table which is owned by another user? (Oracle Database 10g Express Edition, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can I build an application using a table which is owned by another user? [message #435901]

Fri, 18 December 2009 13:20

Beginner Girl
Messages: 2
Registered: December 2009

Junior Member

Greetings,

I'm very beginner in Oracle, and I really need help in this point.
I have created 2 user accounts: user1 & user2.

In user1, I wrote:

grant CONNECT, RESOURCE
to user2;

grant select, insert, update
on table1
to user2;

Now, user2 can see the content of that table, but only in the SQL part (select * from user1.table1)
How can I create in user2 an application that uses table1?
When I go to application builder, I have to choose one of the tables owned by this user2. But I can't use table1 of user1 although this user2 has a permission to access it.

Any help?

Thank you in advance!

Beginner Girl

Report message to a moderator

Re: Can I build an application using a table which is owned by another user? [message #435915 is a reply to message #435901]

Fri, 18 December 2009 23:33

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Don't know exactly, but I think SYNONYM can help you out.
Just try it, and reply what happens.

regards,
Delna

Report message to a moderator

Re: Can I build an application using a table which is owned by another user? [message #435917 is a reply to message #435901]

Fri, 18 December 2009 23:43

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

In ApEx, before giving list of all tables/views you can select from, it also asks about owner of that table/view.
At that time, you select USER1.
That set.

regards,
Delna

Report message to a moderator

Re: Can I build an application using a table which is owned by another user? [message #435918 is a reply to message #435901]

Fri, 18 December 2009 23:48

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Ok,
SYNONYM wont be helpful in this case.
You have to compulsary follow previously suggested way.

Just select USER1 as owner of the table/view.
Then select TABLE1 as table/view.

regards,
Delna

Report message to a moderator

Re: Can I build an application using a table which is owned by another user? [message #435930 is a reply to message #435918]

Sat, 19 December 2009 03:06

Beginner Girl
Messages: 2
Registered: December 2009

Junior Member

Thanks for your help.

In the step of asking about which schema I want to select a table from, the drop down menu contains only the schema of the current user which I logged in. The other users don't appear, so I can't choose them.

Any idea?

Thanks again.

Regards,
Beginner Girl

Report message to a moderator

Re: Can I build an application using a table which is owned by another user? [message #435931 is a reply to message #435930]

Sat, 19 December 2009 03:13

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Does USER1 and USER2 belongs to same database?

In which component of ApEx, do you require to select table name?

regards,
Delna

[Updated on: Sat, 19 December 2009 03:17]

Report message to a moderator

Re: Can I build an application using a table which is owned by another user? [message #435997 is a reply to message #435931]

Sun, 20 December 2009 22:52

StudentOfOracle
Messages: 12
Registered: April 2008
Location: Lahore

Junior Member

Hi,
I think u cannot build such a application where u called two difference schamas table. but u insert modify delete record in different schma table.

Report message to a moderator

Previous Topic:	mod_plsql authentication with sso
Next Topic:	Printer Friendly Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 20:01:19 CST 2024