I Use SQl Develpoer Version 4.1.3 and i can't see the created Procedure-Code from the Procedures in my Schema. I only get "create or replace" - thats it. No more Code from the Procedure. If i Use TOAD with the same User and the same rights i can see the code of the Procedures.
Here is the Userscript:
DROP USER myUSER CASCADE;
CREATE USER myUSER
IDENTIFIED BY <password>
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 2 Roles for myUSER
GRANT CONNECT TO myUSER;
GRANT RESOURCE TO myUSER;
ALTER USER myUSER DEFAULT ROLE ALL;
-- 15 System Privileges for myUSER
GRANT ALTER SESSION TO myUSER;
GRANT CREATE DATABASE LINK TO myUSER;
GRANT CREATE JOB TO myUSER;
GRANT CREATE MATERIALIZED VIEW TO myUSER;
GRANT CREATE PROCEDURE TO myUSER;
GRANT CREATE SEQUENCE TO myUSER;
GRANT CREATE SESSION TO myUSER;
GRANT CREATE TABLE TO myUSER;
GRANT CREATE TRIGGER TO myUSER;
GRANT CREATE VIEW TO myUSER;
GRANT DEBUG ANY PROCEDURE TO myUSER;
GRANT EXECUTE ANY PROCEDURE TO myUSER;
GRANT SELECT ANY SEQUENCE TO myUSER;
GRANT SELECT ANY TABLE TO myUSER;
GRANT UNLIMITED TABLESPACE TO myUSER;
What can i do to see the Code?
I can export the Procedures and then i get the full code, So i think i have the rights to see it.