Privs on PL/JSON to access from diff user

farallon
2010-06-10
2013-05-28
  • farallon
    farallon
    2010-06-10

    I have installed PL/JSON and its fantastic. Have a requirement wherein other users on the db needs to be able to access PL/JSON.
    Could you please point me to the list of objects that needs to be provided access to that specific user so that he can work seamlessly and access all the features provided by PL/JSON.

     
  • Thank you for your kind words.
    The object types are: JSON, JSON_LIST, JSON_VALUE and JSON_VALUE_ARRAY
    The necessary packages are: JSON_PRINTER, JSON_PARSER and JSON_EXT
    If you have installed some of the optional packages you can grant access to them too.

    best regards Jonas

     
  • farallon
    farallon
    2010-06-10

    That was an immediate response.
    Thank you so much Jonas.

    Best Regards
    Sri