unless your concerned about the sys admin having access to the passwords,
generally using file level security is suitable to protect scripts with
passwords in them. But that depends on how comfortable you are with the SA,
and if the shop has a fairly stable security structure.
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 6:11 PM
I am working on scripts that will create tables and users, grant
permissions, etc. every night on a clean copy of our db. Without
dbms_sys_sql, I would have to connect to other users to do the grants.
I
don't want passwords anywhere in my scripts, I want to connect once then
run
everything from this one user. dbms_sys_sql takes in a userid and sql
text
(plus a couple of other things) and runs the sql as that user.
Linda
-----Original Message-----
Sent: Friday, May 18, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L
Linda,
you should be using dbms_sql instead, which incidentally is *very*
stable.
What feature of dbms_sys_sql you need but isn't provided by dbms_sql? I
am
just curious ...
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
QOTD: Any clod can have facts, but having an opinion is an art !
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seley, Linda
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Christopher Spence
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
