POn Tue, 2003-02-11 at 18:16, Matthew O. Persico wrote: > On 11 Feb 2003 08:02:25 -0800, Michael Peppler wrote: > >On Tue, 2003-02-11 at 07:30, [EMAIL PROTECTED] wrote: > >>Hi, > >>I am having trouble installing the module. The server is hpux > >>11X > >>with sybase 12.0. Any help would be great. > > > >You're OK. The error is just a permission problem, because the test > >scripts really require "sa" permissions at the moment (to create a > >stored procedure in the tempdb database). > > > >I need to change the test scripts to allow you to specify a different > >database to run the tests in so that this doesn't happen. > > Wouldn't tempdb suffice? >
I thought so too. But it doesn't work: troll (6:06PM):26 > sqsh -Uwebuser -Pwebuser -Splum sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray This is free software with ABSOLUTELY NO WARRANTY For more information type '\warranty' [21] plum.mp3: 1> use tempdb [21] plum.mp3: 2> go [22] plum.tempdb: 1> create proc foo as select * from sysusers [22] plum.tempdb: 2> go Msg 10331, Level 14, State 1 Server 'plum', Procedure 'foo', Line 1 CREATE PROCEDURE permission denied, database tempdb, owner dbo [23] plum.tempdb: 1> And I definitely have not changed anything in the setup on that server. Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html
