DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2000


    I have around 400 tables which belong to a schema lawd. I have created
    a role called select_role and want to give only select privileges to that role on all
    these tables belonging to lawd.
    can i do it with one single command , i tried the security manager but
    it does not allow me to select multiple tables and grant the select.
    I logged in as lawd and tried the grant select any table to select_role ,
    but since lawd is not a dba (i dont want to make it a dba user) this
    comes out with insufficient privileges.
    How do i do it with a single command or select all tables in one go
    at the security manager (tried holding shift+ctrl key , does not work)

    Thanks !


  2. #2
    Join Date
    Jan 2000
    I don't user security manager but this is how I do it. I create a script spooled out from sqlplus that I run

    set heading off
    set pagesize o
    spool cr_grant.sql
    select 'grant select on '||table_name||' to select_role;'
    from dba_tables
    where owner = 'LAWD';
    spool off

    I then would log in as lawd and execute the script.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.