Re: [Virtuoso-users] file_to_string and dba privileges

[Hugh W. <hwi...@op...>]

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, <bmi...@or...> 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
> Vir...@li...
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users