Re: Simple PL/SQL Problem

login as bozo and give grant to the table

as Grant select, update, insert, delete on students to krusty

u shud be able to access the table from the krusty login henceforth

HTH
Arvind

Sean Phillips wrote:

> Hello All,
>
> I am as green as they come, so forgive me if this the answer to this is
> painfully obvious. I have no one else in the company I can ask, so
> please humor me.
>
> My problem is this: I cannot reference a table in another users schema
> while trying to compile a PL/SQL procedure. For example, a table exists
> called 'students' created by a user 'bozo'. The table has 3 elements:
> first_name, last_name, student_id.
>
> I am connected as 'krusty' and I am trying to compile a procedure that
> references the 'students' table of 'krusty's. For each variable in the
> table, I reference them as follows:
>
> v_FirstName bozo.students.first_name%TYPE
> v_LastName bozo.students.last_name%TYPE
> v_StudentID bozo.students.student_id%TYPE
>
> Later, the procedure tries to insert into the table as follows:
>
> INSERT INTO bozo.students(v_FirstName, v_LastName,v_StudentID) AS
> VALUES (n_FirstName,n_LastName,n_StudentID) ;
>
> I get a PLS-201 error which is complaining about me not declaring the
> 'BOZO.STUDENTS' identifier.
>
> I can successfully compile this procedure all day long as the user bozo,
> but as krusty I constantly get the error described above. I have
> granted damn near every privilege to krusty known to humankind.
>
> Any hints, tips, clues would be greatly appreciated.
>
> Scuffling,
> Sean Phillips

--
Balaraman Arvind
151 Andrew Ave, Apt 215
Naugatuck, CT 06770

ph   -  (203)-723-1190(R)
     -  (203)-459-7502(O)

mail -  dnivra_at_ix.netcom.com (R)
        abalaram_at_oxhp.com    (O)