Grant Select on all Tables Owned By Specific User

by

Well, it’s not a single statement, but it’s about as close as you can get with oracle:

BEGIN
   FOR R IN (SELECT owner, table_name FROM all_tables WHERE owner="TheOwner") LOOP
      EXECUTE IMMEDIATE 'grant select on '||R.owner||'.'||R.table_name||' to TheUser';
   END LOOP;
END;

More Related Contents:

  1. Printing the value of a variable in SQL Developer
  2. Passing an array of data as an input parameter to an Oracle procedure
  3. Oracle Equivalent to MySQL INSERT IGNORE?
  4. null vs empty string in Oracle [duplicate]
  5. Convert comma separated string to array in PL/SQL
  6. UTL_FILE.FOPEN() procedure not accepting path for directory?
  7. Oracle stored procedure with parameters for IN clause
  8. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  9. NLS_NUMERIC_CHARACTERS setting for decimal
  10. Formatting DATE in oracle
  11. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  12. Oracle: How to find out if there is a transaction pending?
  13. Best practice for pagination in Oracle?
  14. Split function in oracle to comma separated values with automatic sequence
  15. check if “it’s a number” function in Oracle
  16. Sql*plus always returns exit code 0?
  17. ORA-06508: PL/SQL: could not find program unit being called
  18. ORA-12170: TNS:Connect timeout occurred
  19. How to create and use temporary table in oracle stored procedure?
  20. SQL*Plus how to accept text variable from prompt?
  21. How to find difference b/w TIMESTAMP format values in Oracle?
  22. if (select count(column) from table) > 0 then
  23. How to find out when an Oracle table was updated the last time
  24. Using Alias in query resulting in “command not properly ended”
  25. NLS_LANG setting for JDBC thin driver?
  26. How can I describe a table in Oracle without using the DESCRIBE command?
  27. Get the LENGTH of a LONG RAW
  28. Oracle: Days between two date and Exclude weekdays how to handle negative numbers
  29. Why cannot I create triggers on objects owned by SYS?
  30. How to View Oracle Stored Procedure using SQLPlus?

Leave a Comment