#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2005
    Posts
    18
    Rep Power
    0

    How to grant execute on any procedure?


    Hi all,

    in oracle it is possible to grant execute to any procedure.
    Is it possible in firebird?

    Thanks,
    Andrej.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2004
    Location
    Sarajevo, Bosnia
    Posts
    120
    Rep Power
    13
    Originally Posted by 1andy1
    Hi all,

    in oracle it is possible to grant execute to any procedure.
    Is it possible in firebird?

    Thanks,
    Andrej.
    I don't understand your question...
    But, to grant execute on some procedure, try this:


    GRANT EXECUTE ON PROCEDURE PROCEDURE_NAME TO SOME_USER;


    --
    Best regards,
    Fikret Hasovic http://fikret.fbtalk.net
    TAMP R&D Team
    FirebirdSQL Foundation member.
    - Join today at http://www.firebirdsql.org/ff/foundation
    JEDI VCS contributor
    http://jedivcs.sourceforge.net/
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2005
    Posts
    18
    Rep Power
    0

    grant any procedure


    In oracle it is possible to write
    GRANT EXECUTE ANY PROCEDURE TO user_name WITH ADMIN OPTION;
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2009
    Location
    Canada
    Posts
    1
    Rep Power
    0

    hi from Canada


    hi everyone,It feels really nice to be part of this special community. Anyone from Canada here?
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2011
    Posts
    6
    Rep Power
    0
    GRANT EXECUTE Procedure/function TO user_name

IMN logo majestic logo threadwatch logo seochat tools logo