SQL> desc apps.xxta_inter_acces;
FUNCTION apps.xxta_inter_acces RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
P_SR VARCHAR2 IN
P_TEL VARCHAR2 IN
SQL> create user xxalj identified by xxalj;
User created.
SQL> grant connect,resource to xxalj;
Grant succeeded.
SQL> grant select on dual to xxalj;
Grant succeeded.
SQL> conn apps/taapps11i
Connected.
grant execute on apps.xxta_inter_acces to xxalj;
SQL> conn xxalj/xxalj
Connected.
SQL> desc apps.xxta_inter_acces;
FUNCTION apps.xxta_inter_acces RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
P_SR VARCHAR2 IN
P_TEL VARCHAR2 IN
OBJECT_NAME
--------------------------------------------------------------------------------
OWNER OBJECT_TYPE
------------------------------ -------------------
XXTA_INTER_ACCES
APPS FUNCTION
No comments:
Post a Comment