How do I set a Database Role for a SQL*Loader Session?
From: Jerry Murr <jdm2_at_lsdn2.ksc.nasa.gov>
Date: 1995/10/31
Message-ID: <475e91$ee2_at_niven.ksc.nasa.gov>#1/1
Date: 1995/10/31
Message-ID: <475e91$ee2_at_niven.ksc.nasa.gov>#1/1
SQL*Loader requires the user have insert/delete privileges on the table(s) being loaded. Is there a way to obtain these privileges via a (non-default) database role, i.e., the user (or software) uses something analogous to the "set role" command to obtain the needed privileges for a SQL*Loader session?
Are there plans to include a "set role" parameter in any future release of SQL*Loader? Received on Tue Oct 31 1995 - 00:00:00 CET