[Virtuoso-users] file_to_string and dba privileges

2011-11-28 Thread bmillemathias.ext
Hello, While looking to a way to dump data on 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

[Virtuoso-users] file_to_string and dba privileges

2011-11-28 Thread bmillemathias.ext
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

Re: [Virtuoso-users] file_to_string and dba privileges

2011-11-28 Thread bmillemathias.ext
] 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

Re: [Virtuoso-users] file_to_string and dba privileges

2011-11-28 Thread Hugh Williams
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: