RE: Granting Select Any Table

What I normally do is create a role and grant all the objects of the schema to that role. Then I just grant the role the users. It reduces maintenance and is more clean.

Thanks
Abhimanyu

• "Koivu, Lisa" <lkoivu_at_qode.com> wrote:
  > Larry, it seems to me you are asking if there's a
  > schema specific way to do
  > this - for example, to grant 'select any
  > schemaname.table' to a different
  > user.
  >
  > If that's what you are asking, no, there isn't.
  > It's a big smear with
  > select any table (every single table in the db), or
  > table specific grants.
  >
  > You can create the SQL for table specific grants
  > easily with dynamic sql:
  >
  > spool file.sql
  > SELECT 'grant select on ' || table_name || ' to
  > scott;'
  > from user_Tables;
  > spool off
  >
  > @file
  >
  > HTH
  >
  > Lisa Rutland Koivu
  > Oracle Database Administrator
  > Qode.com
  > 4850 North State Road 7
  > Suite G104
  > Fort Lauderdale, FL 33319
  >
  > V: 954.484.3191, x174
  > F: 954.484.2933
  > C: 954.658.5849
  > http://www.qode.com
  >
  > "The information contained herein does not express
  > the opinion or position
  > of Qode.com and cannot be attributed to or made
  > binding upon Qode.com."
  >
  >
  > -----Original Message-----
  > Sent: Thursday, December 14, 2000 1:57 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > grant select any table to your_user;
  >
  > This works,
  > Ruth
  > ----- Original Message -----
  > To: "Multiple recipients of list ORACLE-L"
  > <ORACLE-L_at_fatcity.com>
  > Sent: Thursday, December 14, 2000 12:44 PM
  >
  >
  > > Hi folks,
  > >
  > > Does anyone know the best way to grant a user
  > select any table of another
  > > users tables?
  > >
  > > Thanks in advance
  > >
  > > Larry
  > > --
  > > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > > --
  > > Author: Larry Taylor
  > > INET: ltaylor_at_iq.com
  > >
  > > Fat City Network Services -- (858) 538-5051
  > FAX: (858) 538-5051
  > > San Diego, California -- Public Internet
  > access / Mailing Lists
  > >
  >

  ---

  
  > > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > > (or the name of mailing list you want to be
  > removed from). You may
  > > also send the HELP command for other information
  > (like subscribing).
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Ruth Gramolini
  > INET: rgramolini_at_tax.state.vt.us
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  >
  

  ---