Error 42000
SQ070:SECURITY: Must have SELECT privileges on view WS.WS.SYS_DAV_USER for group ID 136 (vdb), user ID 136 (vdb)
while executing the following statement:
#line 15870 "/DAV/VAD/conductor/folder.vspx-sql"
create method vc_data_bind_dav_mime2 (inout control vspx_data_list , inout e vspx_event) for "DB"."vdb".page__DAV_VAD_conductor_folder_vspx
{
--no_c_escapes-
declare path, params, lines any;
if (not control.vc_enabled)
{
return 1;
}
path := e.ve_path;
params := e.ve_params;
lines := e.ve_lines;
if (not control.vc_instantiate)
{
control.vc_instantiate := 1;
self.vc_init_dav_mime2 (control, control.vc_parent);
if (self.vc_page.vc_is_postback and e.ve_button is null)
self.vc_get_focus (e);
}
-- v:before-data-bind controls:
--no_c_escapes-
{
control.ufl_value := get_keyword ('dav_mime2', self.vc_page.vc_event.ve_params, WEBDAV.DBA.DAV_GET (self.dav_item, 'mimeType'));
}
if (not control.vc_enabled)
{
return;
}
-- Databound fields of the control:
-- Databound HTML attributes:
control.vc_set_attribute ('id', 'dav_mime2');
{
declare items, item_values any;
control.vsl_items := vector ();
control.vsl_item_values := vector ();
items := vector ();
item_values := vector ();
for select '' as T_TYPE from WS.WS.SYS_DAV_USER where U_NAME = 'dav' union all select distinct T_TYPE from WS.WS.SYS_DAV_RES_TYPES order by T_TYPE do
{
items := vector_concat(items, vector(sprintf('%V', cast(T_TYPE as varchar))));
item_values := vector_concat(item_values, vector(sprintf('%V', cast(T_TYPE as varchar))));
}
control.vsl_items := items;
control.vsl_item_values := item_values;
control.vs_set_selected ();
}
#line 837 "http://local.virt/vspx"
}
in
signal:(BIF),
__01 => '42000',
__02 => 'SQ070:SECURITY: Must have SELECT privileges on view WS.WS.SYS_DAV_USER for group ID 136 (vdb), user ' (truncated),
DB.DBA.vspx_load_sql([executable]/vspx.sql:5493),
vspx_dbname => 'DB',
vspx_user => 'vdb',
resource_name => '/DAV/VAD/conductor/folder.vspx',
sql_name => '/DAV/VAD/conductor/folder.vspx-sql',
signal:(BIF),
__01 => '42000',
__02 => 'SQ070:SECURITY: Must have SELECT privileges on view WS.WS.SYS_DAV_USER for group ID 136 (vdb), user ' (truncated),
DB.DBA.vspx_dispatch([executable]/vspx.sql:5836),
resource_name => '/DAV/VAD/conductor/folder.vspx',
path => (ARRAY_OF_POINTER value, tag 193),
params => (ARRAY_OF_POINTER value, tag 193),
lines => (ARRAY_OF_POINTER value, tag 193),
class_name => 'page__DAV_VAD_conductor_folder_vspx',
compile_only => 0,
vspx_dbname => 'DB',
vspx_user => 'vdb',
WS.WS.DAV_DIR_LIST([executable]/dav.sql:6564),
path => (ARRAY_OF_POINTER value, tag 193),
params => (ARRAY_OF_POINTER value, tag 193),
lines => (ARRAY_OF_POINTER value, tag 193),
full_path => '/DAV/virtuoso/Public/VADs/',
logical_root_path => '/vads/',
col => 2271,
auth_uname => NULL,
auth_pwd => NULL,
auth_uid => 136,
WS.WS.GET([executable]/dav.sql:2835),
path => (ARRAY_OF_POINTER value, tag 193),
params => (ARRAY_OF_POINTER value, tag 193),
lines => (ARRAY_OF_POINTER value, tag 193)