Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Grant User Privileges

RE: Grant User Privileges

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Tue, 19 Dec 2000 12:14:50 +1100
Message-Id: <10714.124886@fatcity.com>


Larry,

yes.
If you do not put in the where clause it would grant select on all the tables
owner by tiger to scott.

Suhen

-----Original Message-----
From: Larry Taylor [mailto:ltaylor_at_iq.com] Sent: Tuesday, December 19, 2000 11:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: Grant User Privileges

Thanks Suhen for your help.

Does '||table_name|| ' to SCOTT; grant select on all tables owned by Tiger?

larry

-----Original Message-----
Sent: Monday, December 18, 2000 3:58 PM
To: Multiple recipients of list ORACLE-L

Login as Tiger
select 'grant select on '||table_name|| ' to SCOTT;' from user_tables where table_name not in ('T_PROGRAM','T_LOG','T_OWN','T_ORG') ;

You cannot grant select privilege on a column. Only insert, update, reference.
The workaround is to create a view with the respective columns and then grant select on the view to the user.

HTH Suhen

-----Original Message-----
Sent: Tuesday, December 19, 2000 10:26 AM To: Multiple recipients of list ORACLE-L

Hi all,

How would I grant user Scott select on all the tables owned by user Tiger with the
exception of t_program, t_log, t_own and t_org.

In addition allow Scott is select certain columns of table views: v_program, v_log, v_own and v_org.

Does anyone have any suggestions?

Thanks.
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: Suhen Pather
  INET: Suhen.Pather_at_strandbags.com.au
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: 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 Received on Mon Dec 18 2000 - 19:14:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US