RE: Grant User Privileges

From: Djordje Jankovic <djankovic_at_corp.attcanada.ca>
Date: Mon, 18 Dec 2000 23:32:32 -0500
Message-Id: <10714.124894@fatcity.com>

Larry,

The statement that Suhen has given to you will create a list of grant statements, one for each table. After you get that list, you have to run those statements. If you want to do that automatically, you can spool the result of Suhem's statement to a file, and that execute that file (@filename).

HTH Djordje

-----Original Message-----
From: Suhen Pather
To: Multiple recipients of list ORACLE-L Sent: 12/18/00 8:15 PM
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
--------------------------------------------------------------------