Hi Hugh, Thanks for the hint, I'll look in that direction.
Thanks -----Message d'origine----- De : Hugh Williams [mailto:[email protected]] Envoyé : lundi 28 novembre 2011 14:14 À : MILLE MATHIAS Baptiste Ext DMGP/PORTAIL Cc : [email protected] Objet : Re: [Virtuoso-users] file_to_string and dba privileges Hi You can wrap the function(s) that require DBA privileges in Virtuoso into a store procedure which is then granted DBA privileges to allow it to run with such privileges but can be called by a none DBA user ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 28 Nov 2011, at 11:32, <[email protected]> wrote: > Hello, > > While looking to a way to dump data from the database to disk, I used the > function file_to_string but it requires DBA permissions; due to that I can't > use that function in script to automate export in production environment, as > it is unsafe to grant DBA permission to any user in the wild. > > Is there a way to circumvent this, by using another function ? > Why does it require DBA permission and not a file permission as it exist in a > SGDB like mysql ? > > Thanks > > _________________________________________________________________________________________________________________________ > > Ce message et ses pieces jointes peuvent contenir des informations > confidentielles ou privilegiees et ne doivent donc pas etre diffuses, > exploites ou copies sans autorisation. Si vous avez recu ce message par > erreur, veuillez le signaler a l'expediteur et le detruire ainsi que les > pieces jointes. Les messages electroniques etant susceptibles d'alteration, > France Telecom - Orange decline toute responsabilite si ce message a ete > altere, deforme ou falsifie. Merci > > This message and its attachments may contain confidential or privileged > information that may be protected by law; they should not be distributed, > used or copied without authorization. If you have received this email in > error, please notify the sender and delete this message and its attachments. > As emails may be altered, France Telecom - Orange shall not be liable if this > message was modified, changed or falsified. Thank you. > > > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure > contains a definitive record of customers, application performance, > security threats, fraudulent activity, and more. Splunk takes this > data and makes sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-novd2d > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users _________________________________________________________________________________________________________________________ Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par erreur, veuillez le signaler a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant susceptibles d'alteration, France Telecom - Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci This message and its attachments may contain confidential or privileged information that may be protected by law; they should not be distributed, used or copied without authorization. If you have received this email in error, please notify the sender and delete this message and its attachments. As emails may be altered, France Telecom - Orange shall not be liable if this message was modified, changed or falsified. Thank you.
