Report problems to ATLAS LXR Team (with time and IP address indicated) |
|
[ source navigation ] [ diff markup ] [ identifier search ] [ general search ] |
||||
|
||||||
Links to LXR source navigation pages for stable releases | [ 12.*.* ] [ 13.*.* ] [ 14.*.* ] |
001 -- 002 -- Generate script which can be run against the database 003 -- to grant privileges to roles created in previous 004 -- script 005 -- J. Cranshaw 29.06.05 006 -- 007 set pagesize 0; 008 set heading off; 009 set feedback off; 010 set verify off; 011 set echo off; 012 set serveroutput on; 013 014 spool privs_list.grt; 015 016 declare 017 cursor c1 is select table_name from user_tables; 018 begin 019 dbms_output.enable(100000); 020 for i in c1 loop 021 dbms_output.put_line('GRANT SELECT ON '||i.table_name||' TO ATLAS_TAGS_ROME_SELECT;'); 022 dbms_output.put_line('GRANT INSERT ON '||i.table_name||' TO ATLAS_TAGS_ROME_INSERT;'); 023 dbms_output.put_line('GRANT UPDATE ON '||i.table_name||' TO ATLAS_TAGS_ROME_UPDATE;'); 024 dbms_output.put_line('GRANT DELETE ON '||i.table_name||' TO ATLAS_TAGS_ROME_DELETE;'); 025 end loop; 026 end; 027 /
[ source navigation ] | [ diff markup ] | [ identifier search ] | [ general search ] |
Due to the LXR bug, the updates fail sometimes to remove references to deleted files. The Saturday's full rebuilds fix these problems | |
This page was automatically generated by the LXR engine. |