RE: Grant User Privileges

From: Larry Taylor <ltaylor_at_iq.com>
Date: Thu, 21 Dec 2000 14:31:44 -0800
Message-Id: <10717.125189@fatcity.com>

Suhen,

This does'nt work. Is there a way to modify your script to include tiger.table_name in the select clause and where clause?

I can only grant select on table_name to scott like this:

grant select on tiger.program to scott;

larry

-----Original Message-----
From: Suhen Pather [mailto:Suhen.Pather_at_strandbags.com.au] Sent: Monday, December 18, 2000 5:16 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Grant User Privileges

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-----
Sent: Tuesday, December 19, 2000 11:44 AM To: Multiple recipients of list ORACLE-L

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

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------