Re: Stored Procedures and PowerBuilder

In article <1995Jun26.134558.96365_at_kuhub.cc.ukans.edu>, mahesh_at_tisl.ukans.edu (Rachakonda Satya) says:
>
>
>Hi,
>
>I declared a few stored functions with Oracle, gave them public synonyms and am
>trying to access them from Power Builder. The problem I am facing is that the user is able to access those functions only with DBA privele
>
>Can anyone please help me with this? I sincerely thank in advance. I also requ
>est a direct reply to my address.
>
>Thank you,
>
>mahesh
>
>--
>Rachakonda Satya Mahesh res: (913) 749-7540
>University of Kansas, Lawrence off: (913) 864-7374
>mahesh_at_cecase.ukans.edu fax: (913) 864-7789
>--
>Rachakonda Satya Mahesh res: (913) 749-7540
>University of Kansas, Lawrence off: (913) 864-7374
>mahesh_at_cecase.ukans.edu fax: (913) 864-7789

You should be able to create the objects under any SCHEMA and then grant execute to thoses users/roles that need to use it. After the grant is performed, the users will see the SPs in their lists.

Eric A. Stephens
Syracuse, NY
estephe1_at_csc.com
eastephe_at_mailbox.syr.edu
http://web.syr.edu/~eastephe Received on Sat Jul 01 1995 - 00:00:00 CEST