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
smime.p7s
Description: S/MIME cryptographic signature
