plsql - What are invoker's rights with respect to Oracle PL/SQL functions? -


the first of result_cache usage restrictions (--link) - not defined in module has invoker's rights or in anonymous block.

what "invoker's rights" mean ? mean user_procedures.authid shouldnt "definer" function ?

invoker , definer rights when executing oracle pl/sql code

the rule interpreting restricts usage of kinds of pl/sql code stored in database cache. types of pl/sql code included segments within:

  1. anonymous blocks (i.e., these code snippets run through sql plus or other input without being part of persistent object in database, such stored procedure, function or package)
  2. defined invoker's rights: (see below explanation)

an invoker means whatever user account executes pl/sql object, procedure runs privileges of user account instead of customary privileges of definer (owner of object).

tom kyte has a discussion thread on topic of definer vs. invoker rights on ask-tom site.

the notable comment above reference example block of code:

in above, if user1 created:  create or replace procedure proc1 authid current_user begin    x in ( select * my_table ) loop       null;    end loop; end; /

in following line: authid current_user, comment setting invoker's rights. table my_table in reference has multiple possibilities:

  • when proc1 executed definer , invoker same, (i.e., owner or user1) table be: user1.my_table
  • when proc1 executed invoker or user other owner of procedure proc1, (i.e., user2) table can 1 of these possible targets:
    • a public owned table named my_table
    • a private or publicly owned synonym table typed object called my_table
    • a local table owned user2 (i.e., user2.my_table) of same name, my_table.

if above cases true, there great deal of ambiguity surrounding reference involved procedure user1.proc1. actual, physical table being used different based on context of invoking user identity , accessibility/existence of aliased pointers (synonyms).

the result usefulness of cached value procedure invoker's rights enabled questionable given variable nature of internal references.


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

inno setup - TLabel or TNewStaticText - change .Font.Style on Focus like Cursor changes with .Cursor -

is possible change .font.style on focus tlabel or tnewstatictext happens cursor when use .cursor ? there no built-in support track mouse hovering in inno setup @ time. however, intercepting window procedure of controls can track yourself. following example need innocallback library: [setup] appname=my program appversion=1.5 defaultdirname={pf}\my program outputdir=userdocs:inno setup examples output [files] source: "innocallback.dll"; destdir: "{tmp}"; flags: dontcopy [code] #ifdef unicode #define aw "w" #else #define aw "a" #endif const gwl_wndproc = -4; wm_mousemove = $0200; type wparam = uint_ptr; lparam = longint; lresult = longint; twindowproc = function(hwnd: hwnd; umsg: uint; wparam: wparam; lparam: lparam): lresult; function setcapture(hwnd: hwnd): hwnd; external 'setcapture@user32.dll stdcall'; function releasecapture: bool; external 'releasecapture@user32.dll stdcall'; func...
Read more