Wednesday, September 30, 2020

Oracle Grant privilege to function


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

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts