RE: Granting SELECT permissions to a user based

Do one thing.
run this script in user MAIN.

spool C:\main.sql
select 'grant select on '||tname||' to U;' from tab; spool off

after this edit C:\main.sql accordingly. run it from MAIN user
@c:\main.sql

this will grant select permission on all tables of MAIN to U.

Vikas
-----Original Message-----
From: Andreas Jung [mailto:ajung_at_sz-sb.de] Sent: Monday, May 29, 2000 4:17 PM
To: Multiple recipients of list ORACLE-L Subject: Granting SELECT permissions to a user based

Dear all,

I have a schema MAIN that holds all my tables. I want to create a user U that should have only SELECT permissions on the complete schema MAIN. How can I grant these permissions to the user without granting SELECT permission on every table of MAIN.* ?

Andreas

-- 
Author: Andreas Jung
  INET: ajung_at_sz-sb.de

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).