How to refer to a non active user object???

[skanat]

One more thing:

How can I refer to a different user object. For example, I'm programming as a user (called 'noupo8') and I created another user ('no_id_user'). Just to have procedures with owa_custom authentification and anothers with Basic authentification.

Connected by NO_ID_USER (dba privileges), in a procedure of its own, I want to make a SELECT of an object from NOUPO8. Both of them (the users) are GRANT as 'dba' and ORACLE says to me: 'NOUPO8.TABLE_NAME MUST BE DECLARED'.... What happens????

Thanks people.
Bernat

 

[skanat]

I found the answer in my own: I just dont' had GRANT privileges to the object. Then I created a Synonim and then I can refer other users objects.

thakns!

Originally posted by skanat:
One more thing:

How can I refer to a different user object. For example, I'm programming as a user (called 'noupo8') and I created another user ('no_id_user'). Just to have procedures with owa_custom authentification and anothers with Basic authentification.

Connected by NO_ID_USER (dba privileges), in a procedure of its own, I want to make a SELECT of an object from NOUPO8. Both of them (the users) are GRANT as 'dba' and ORACLE says to me: 'NOUPO8.TABLE_NAME MUST BE DECLARED'.... What happens????

Thanks people.
Bernat