ERPstuff - Oracle EBS Community

Asslam-o-Alailkum All Members.

Here is a Little Query about creating a public Function. which can be accessable from all database users. with out giving any RIGHTS for EXECUTE that funcion.
As all the other built-in Oracle functions can be accessed from all users with out giving any special rights to EXECUTE that functions.

Any Help or Idea will be appreciated.


Best Regards.

Muhammad Kashif

You will have to grant to public instead of a specific user,

Example:
grant select on emps to public;

grant select on emps to public;

Thanks Mr. Admin
Its working. Thank u Very Much.
Anohter Question here is.
we have to Give the SCHEMA Name Before Function Name.
How Can we Elliminate this.


Best Regards.

Muhammad Kashif

Synonyms will be used for this.

Thanks u Very much Mr. Admin.
I found The Solution with ur Help.
Thanks Again.

Best Regards.

Muhammad Kashif