Problem in Create Store Procedure use non-schema owner account

From: <anthonywmhui_at_hotmail.com>
Date: Wed, 09 Jun 1999 03:36:37 GMT
Message-ID: <7jkng4$89o$1@nnrp1.deja.com>

Hi,

I created all database objects(table, indexes) use the account CCRDEV and grant select, update, insert and delete to a ROLE. This role is then granted to a user DCCRMGR. I describe the table RULE use the DCCRMGR account and everything Ok. However, when I try to create a Store Procedure that access RULE, the following error appear

LINE/COL ERROR
-------- ---------------------------------------------------------------
--

32/2 PL/SQL: SQL Statement ignored
32/35 PLS-00201: identifier 'CCRDEV.RULE' must be declared SQL> I had spent a few hours to find out the cause but failed. Finally, I grant the table directly to the user(not through the role) and compile the SP again. It was compiled successfully!

Did anyone encounter the same problem before?? Can anyone tell me why? It that mean I can not use ROLE to manage access privileges?

Thanks,
Anthony Hui
Database Design Analyst

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 08 1999 - 22:36:37 CDT