/* buildinstall/11.0.3.3 ESD#6/P-FREE/Linux Intel/Linux 2.2.14 i686/1/OPT/Fri Mar 17 15:47:56 CET 2000 (c) Copyright 1987, 2000. Sybase, Inc. All rights reserved. Unpublished rights reserved under U.S. copyright laws. This software contains confidential and trade secret information of Sybase, Inc. Use, duplication or disclosure of the software and documentation by the U.S. Government is subject to restrictions set forth in a license agreement between the Government and Sybase, Inc. or other written agreement specifying the Government's rights to use the software and any applicable FAR provisions, for example, FAR 52.227-19. Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA. */ use model go if exists (select * from sysobjects where name = 'sp_configure') begin execute sp_configure "allow updates", 1 end go /* Sccsid = "%Z% generic/sproc/src/%M% %I% %G%" */ /* 4.8 1.1 06/14/90 sproc/src/a_permitboth */ grant select on sysalternates to public grant select on syscolumns to public grant select on syscomments to public grant select on sysdepends to public grant select on sysindexes to public grant select on syskeys to public grant select on sysobjects to public revoke select on sysobjects(audflags) from public grant select on sysobjects to sso_role grant select on sysprocedures to public grant select on sysprotects to public grant select on syssegments to public grant select on systypes to public grant select on sysusers to public grant select on syslogs to public grant select on sysconstraints to public grant select on sysreferences to public grant select on sysusermessages to public grant select on sysattributes to public go /* Sccsid = "%Z% generic/sproc/src/%M% %I% %G%" */ /* 4.8 1.1 06/14/90 sproc/src/a_permitboth */ grant select on sysalternates to public grant select on syscolumns to public grant select on syscomments to public grant select on sysdepends to public grant select on sysindexes to public grant select on syskeys to public grant select on sysobjects to public revoke select on sysobjects(audflags) from public grant select on sysobjects to sso_role grant select on sysprocedures to public grant select on sysprotects to public grant select on syssegments to public grant select on systypes to public grant select on sysusers to public grant select on syslogs to public grant select on sysconstraints to public grant select on sysreferences to public grant select on sysusermessages to public grant select on sysattributes to public go /* Temporarily create the #tempmonitors table so it exists ** for the creation of the subordinate sysmon stored procedures. ** ** It will be dropped before sp_sysmon is loaded. ** ** History: ** 01/25/96 (maxb) Created for bugid 82625 */ create table #tempmonitors ( group_name char(25), field_name char(35), field_id smallint, value int) go dump transaction model to diskdump with truncate_only go use master go sp_configure "allow updates", 0 go print 'Loading of model database is complete.' go