How to create view db2/iseries with not default permissions? -

-

everytime create new view have change permissions all, , it's quite painfully lot of times same thing.

i ask if possible change default options in database create view in order permissions set public.

thanks

it sounds using sql naming. use system naming instead, grant public authority according qcrtaut system value. see birgitta hauser's article.

system naming has added advantage of using job's library list resolve unqualified object references. not hard-coding schema names, allowing system find them according library list, enabling code work in different environments (ex. development, testing, training, production) without modifying code, running different library list. therefore can install code production same code tested.


Comments

Post a Comment

Popular posts from this blog

stringtemplate - StringTemplate4 if conditional with length -

-
i need generate following kinds of code stringtemplate4: methodfoo0(connection conn); methodfoo1(connection conn, int arg1); methodfoo2(connection conn, int arg1, int arg2); etc. the "connection conn" part present passing method name , rest of arguments st template. template looks follows: <methodname>(connection conn, <args; separator=", ">); this works produces comma when there no arguments @ (except conn): methodfoo0(connection conn,); to eliminate comma tried using if conditional , length st4 function couldn't work although tried various combos following: <methodname>(connection conn <if (length(fieldsinfind) \> 0)>,<else><endif><fieldsinfind; separator=", ">) ... , others failed parsing-related error ( mismatched input ). in end, gave , resorted passing comma parameter template either "," or empty string "" based on pre-rendering logic. you check p
Read more

shader - OpenGL Shadow Map -

-
i trying basic shadow map reason doesn't render properly. video of problem i render house using flat shader: int shadowmapwidth = window_size_x * (int)shadow_map_ratio; int shadowmapheight = window_size_y * (int)shadow_map_ratio; // rendering shadow texture. glactivetexture(gl_texture0); call_gl(glbindtexture(gl_texture_2d, shadowtexture)); // bind framebuffer. call_gl(glbindframebuffer(gl_framebuffer, shadowfbo)); //clear call_gl(glclear(gl_depth_buffer_bit)); call_gl(glviewport(0, 0, shadowmapwidth, shadowmapheight)); call_gl(glcolormask(gl_false, gl_false, gl_false, gl_false)); //render stuff flatshader.use(); flatshader["basecolor"] = glm::vec4(1.0f,1.0f,1.0f,1.0f); flatshader["pvm"] = projectionmatrix*pointlight.viewmatrix*cursor.modelmatrix; cursor.draw(); //binds vao , draws // revert scene. call_gl(glbindframebuffer(gl_framebuffer, 0)); call_gl(glcolormask(gl_true, gl_true, gl_true, gl_true)); call_gl(glviewport(0, 0, window_size_x, window_s
Read more