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

Search Discussions

  • Suhen Pather at Dec 18, 2000 at 11:58 pm
    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-----
    From: Larry Taylor
    Sent: Tuesday, December 19, 2000 10:26 AM
    To: Multiple recipients of list ORACLE-L
    Subject: Grant User Privileges

    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).
  • Larry Taylor at Dec 19, 2000 at 12:39 am
    Thanks Suhen for your help.

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

    larry

    -----Original Message-----
    From: Suhen Pather
    Sent: Monday, December 18, 2000 3:58 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Grant User Privileges

    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
  • Suhen Pather at Dec 19, 2000 at 1:14 am
    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
    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
  • Djordje Jankovic at Dec 19, 2000 at 4:32 am
    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
    --------------------------------------------------------------------

    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
    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
  • Larry Taylor at Dec 21, 2000 at 10:31 pm
    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
    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
    --------------------------------------------------------------------

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedDec 18, '00 at 11:23p
activeDec 21, '00 at 10:31p
posts6
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase