Hi,
it depends on what contains this script :
for dba operations give them the necessary DBA privileges or sysdba or
sysoper
for ddl then give them system privileges like create table, index, ...
for dml then give them object privileges as select, update on ....
Best Regards,
Nabila Mekkaoui
DBA Oracle
-----Message d'origine-----
De : Andrea Oracle [mailto:[EMAIL PROTECTED]]
Envoy� : mardi 10 juillet 2001 23:00
� : Multiple recipients of list ORACLE-L
Objet : Privilege problem ?????
Hi all,
I wrote a script for developers to run. I have
svrmgrl, connect internal in the script. The
developer got error since he doesn't have privileges.
So how to make the script runnable by non dbas???
Thanks.
Andrea
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrea Oracle
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: INF/MEKKAOUI
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).
