/SQL/Oracle grant on all tables in schema

Oracle grant on all tables in schema

BEGIN
   FOR R IN (SELECT owner, table_name FROM all_tables 
             WHERE owner='OTHER_SCHEMA') LOOP
      EXECUTE IMMEDIATE 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' ||
                         R.owner || '.' || R.table_name || ' TO MY_SCHEMA';
   END LOOP;
END;

Similar codes

4 votes133 views3 answers
Is not null sql
SQL
0 vote111 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
16 votes140 views1 answer
Sql comment'
SQL
0 vote112 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote132 views1 answer
PSQL use LIKE with timestamps
SQL
1 vote113 views1 answer
T-SQL Alter the column data type
SQL
8 votes132 views1 answer
Oracle search stored procedures for text
SQL
0 vote118 views1 answer
Mysql date format unix timestamp
SQL
1 vote126 views1 answer
Mysql return if it contains
SQL
0 vote120 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL