Header Ads

Oracle Database Table Authorization

oracle dba


Oracle Database Table Authorization


If you are having problems with Oracle Database you are trying to access with Toad for Oracle, you can try. Create a new administration and try to access it.


Here are the codes;
BEGIN
    FOR t IN (select OWNER,TABLE_NAME from dba_tables where owner  like '%HR%')
    LOOP
    EXECUTE IMMEDIATE 'GRANT ALL PRIVILEGES ON '|| t.owner ||'.' || t.table_name ||' TO Admin_Name';
    END LOOP;
    END;
 

No comments

Powered by Blogger.