Message-Id: <10666.120648@fatcity.com> From: Miguel Urosa Ruiz Date: Tue, 31 Oct 2000 09:59:34 +0100 Subject: Re: Error in hotbackup script executed by other user then SYS What about to execute catdbsyn.sql script? HTH Regards, Miguel. Skurský Michal wrote: > Hello, > I have a script (hotbackup from > http://ora.dbasupport.com/oracle/scripts/Detailed/148.shtml) in which cursor > is (for example) declared: > > .... > cursor sidname is > select name > from v$database; > ... > ... > begin > open sidname; > loop > fetch sidname into zsidname; > exit when sidname %notfound; > end loop; > ... > ... > > This script can be executed only from user SYS. With other users (with DBA > role, for example system) generates a series of errors, for example: > > Creating hotbackup script... > from v$database; > * > ERROR on row 5: > ORA-06550: row 5, column 6: > PLS-00201: identificator 'SYS.V$DATABASE' must be declared > > What privilege have to be granted to the user or where is the problem. > > Thanks Michal > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-2?Q?Skursk=FD_Michal?= > INET: skursky@brn.pvt.cz > > 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@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).