Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    20

    Unanswered: Let all users run the function a created

    Hi,
    I just wanna ask if someone knows how to grant all users the privelege to execute a user-defined function created by a user on Oracle 8i without creating a synonym and .
    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    If you want all users to be able to execute the function without a synonym, then just grant the execute privilege to them directly or to their roles. Or just try grant execute on procedure to public.
    Problem is that all users who want to execute it, should type the schema name before the procedure name. So they hacve to type exec scott.procedure.

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Oct 2003
    Posts
    20

    Let all users run the function a created

    Hi evan,
    thanks for your help but I wanna ask you, if also I want all users to directly use the function created without putting the schema name before the procedure name.
    Example: I created a function substring under user called wintime and I want all users to use directly this function ( substring and not user1.substring,user2.substring,...).
    Do I have to create a synonym for each user ?
    or can I create a synonym to all of them directly?
    Thanks for your help

  4. #4
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    u can create one synonym that can be used by all users, it's called a public synonym :
    create public synonym func_name for func_name.

    Now all privileged users can use it.

    Hope that helps
    Edwin van Hattem
    OCP DBA / System analyst

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •