Error 42000
SQ070:SECURITY: Must have SELECT privileges on view WS.WS.SYS_DAV_USER for group ID 160 (VS_B_1), user ID 160 (VS_B_1)
while executing the following statement:
#line 16065 "/DAV/VAD/conductor/folder.vspx-sql"
create method vc_data_bind_dav_mime2 (inout control vspx_data_list , inout e vspx_event) for "DB"."VS_B_1".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"
}