Privileges problem.

From: Manasa Rao <rao_manasa_at_hotmail.com>
Date: Mon, 04 Dec 2000 17:58:12 -0000
Message-Id: <10700.123545@fatcity.com>

All,

I have created some procedures and gave
grant execute on set_role to public;
which should let them execute the procedure. But the other user is not able to EXECUTE the procedure-set_role in my schema. They get the following error below.

Appreciate any suggestions.

Thanks
Radhika.

12:54:54 SQL> execute set_role(1, NULL, NULL); BEGIN set_role(1, NULL, NULL); END;

      *
ERROR at line 1:

ORA-06550: line 1, column 7:
PLS-00201: identifier 'SET_ROLE' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

---

Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com Received on Mon Dec 04 2000 - 11:58:12 CST