Creating Public Function.

[Kashif]

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

[admin]

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

Example:
grant select on emps to public;

[Kashif]

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

[admin]

Synonyms will be used for this.

[Kashif]

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

Best Regards.

Muhammad Kashif