Hi man :)
Thanks for the fast reply

I gave both the procedure owner and the procedure executer privs to the tables directly and to tables.

SYS >grant create session, select any table,insert any table, execute any procedure to vote;

Still i get this error.

Do u have more suggestions?

thanx :)

This is the response i get when i execute the procedure through the user suppose to execute it (Not the user who created it)


MGR >create or replace
2 procedure VOTING_PROC (p_partid in number, p_areid in number, p_userid in varchar2)
3 is
4 v_EXISTS_IND NUMBER;
5 begin
6 select count(*) INTO v_EXISTS_IND from ELECTION_MASTER.PARTIES where party_id = p_partid;
7 if v_EXISTS_IND = 0
8 then raise_application_error (-20001, 'ILLEGAL PARTY - CHOOSE A LEGAL ONE');
9 end if;
10 if p_areid not in (1, 2)
11 then DBMS_OUTPUT.PUT_LINE (p_areid);
12 raise_application_error (-20001, 'CAN NOT ELECT ON THIS AREA');
13 end if;
14 if p_areid = 1 and p_userid = 'USER1' or p_userid = 'USER2' or p_userid = 'USER3' or p_userid = 'USER4' or p_userid = 'USER5'
15 then insert into ELECTION_MASTER.JER_VOTES ( party_id, votedate, area_id)
16 values ( p_partid, sysdate, p_areid);
17 elsif
18 p_areid = 2 and p_userid = 'USER6' or p_userid = 'USER7' or p_userid = 'USER8' or p_userid = 'USER9' or p_userid = 'USER10'
19 then
20 insert into ELECTION_MASTER.TA_VOTES ( party_id, votedate, area_id)
21 values ( p_partid, sysdate, p_areid);
22 else
23 raise_application_error (-20002, 'YOU ARE AN ALIEN');
24 end if;
25 end;
26 /
create or replace
*
ERROR at line 1:
ORA-01031: insufficient privileges

This is the error messgae shows when i execute it in developer:

Error report:
ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause:    An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
system privileges.
When Trusted Oracle is configure in DBMS MAC, this error may occur
if the user was granted the necessary privilege at a higher label
than the current login.
*Action:   Ask the database administrator to perform the operation or grant
the required privileges.
For Trusted Oracle users getting this error although granted the
the appropriate privilege at a higher label, ask the database
administrator to regrant the privilege at the appropriate label.


:)

I call the procedure with this anonymous block

DECLARE
p_partid number(5);
p_areid number(5);
P_userid varchar2(10);
BEGIN
FOR i IN 1..5
LOOP
p_partid := round(dbms_random.value (1, 5));
p_areid := round(dbms_random.value (1, 2));
P_userid := ('USER' || to_char(round(dbms_random.value(1, 10))));
dbms_output.put_line(p_partid||'p_partid');
dbms_output.put_line(p_areid ||'p_areid ');
dbms_output.put_line(P_userid ||'P_userid ');
vote.VOTING_PROC
(p_partid, p_areid, P_userid);
END LOOP;
COMMIT;
END;
/

and get this:

Error report:
ORA-01950: no privileges on tablespace 'TEL_AVIV_TBS'
ORA-06512: at "VOTE.VOTING_PROC", line 19
ORA-06512: at line 14
01950. 00000 - "no privileges on tablespace '%s'"
*Cause:    User does not have privileges to allocate an extent in the
specified tablespace.
*Action:   Grant the user the appropriate system privileges or grant the user
space resource on the tablespace.

:)

The procedure was already compiled successfully by The user who created it "VOTE".

The user "MGR" is trying to execute it with the anonymous block and gets the error message i pasted before.

I really thank u on all your effort dude :)

ELECTION_MASTER already has tablespace quota

SYS >create user ELECTION_MASTER
2 identified by ELECTION_MASTER
3 default tablespace ELECTION_MASTER_TBS
4 temporary tablespace TEMP
5 quota unlimited on ELECTION_MASTER_TBS;

I gave all users default tablespace and quota except from VOTE.
I gave vote these quota after i got the error message


SYS >ALTER USER VOTE
2 QUOTA UNLIMITED ON TEL_AVIV_TBS;

User altered.

SYS >ALTER USER VOTE
2 QUOTA UNLIMITED ON JERUSALEM_TBS;

SYS >select table_name,
2 tablespace_name
3 from dba_tables
4 where owner = 'ELECTION_MASTER'
5 order by table_name
6 /

TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
JER_VOTES JERUSALEM_TBS
PARTIES ELECTION_MASTER_TBS
RESULTS ELECTION_MASTER_TBS
TA_VOTES TEL_AVIV_TBS

SYS >

Awesome.....It worked :)
Thanx a lot man u'r the best :)