DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SELECT_ANY_TABLE or what

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    I want to give priviledge to a user that he can do select on all tables (means tables of all users) ....but not on tables like DBA_

    how can i do this.


    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    grant select any table will allow him to see dictionary !

    create a script omething like this :-

    SPOOL GRANT_SELECT.SQL

    select 'grant select on owner.'||table_name|| ' to USER;'
    from dba_tables
    where owner = 'TABLE_OWNER'

    SPOOL OFF

    run grant_select.sql
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Sureshy mostly full script for it.
    We can little bit impruve it.

    set pages 0
    set ...

    spool GRANT_SELECT.SQL

    select 'grant select on '||owner||'.'||table_name|| ' to USER_NAME;'
    from dba_tables
    where owner not in ('SYS','SYSTEM')

    SPOOL OFF

    @grant_select.sql


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width