Accesing another user's Table

[lakshman1820]

Hi Friends,

I am able to access a table created by USER2 when i write some select query.

But when i use the same select query inside a Package iam getting a error that table or view does not exist.

Please give me a solution to use that tables inside the package

[debasisdas]

since u r not the owner user ucan't directly select from other users table.

method1:--grant prevelidges from the other user to the current user.

mehod2:--use a dblink which connects to the second user.


Hope this helps you.

[Medhatithi]

since u r not the owner user ucan't directly select from other users table.

method1:--grant prevelidges from the other user to the current user.

mehod2:--use a dblink which connects to the second user.


Hope this helps you.

To access other user's objects, you must specify the schemaname.obje ctname. Or lese you can ask your DBA to create a synonym on that objetc and grant PUBLIC

[Saii]

To access other user's objects, you must specify the schemaname.obje ctname. Or lese you can ask your DBA to create a synonym on that objetc and grant PUBLIC

As you say, you cannot access the table in a package but can access it in simple select, it is possible that the privilege on that table is granted through a role. To access it in packge, you need to have individual select privilege to the table.

[debasisdas]

Yes that might be the possible reason.