🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.opensource
Article #12

Updating IB6 metdata with IBConsole using a script.

#12
From: Todd
Date: Mon, 27 Mar 2006 17:08
48 lines
2986 bytes
Hello,

1. Logged into my database with the SYSDBA user with exclusivity.
2. Added a role to my DB using a script in IBConsole.
3. Logged out of IBConsole.
4. Logged in as the user I created the role for "CHRONICLE".
5. Get the error: "Error connecting to the requested database." Detail 
Message: "Database C:\DATA\TEST.GDB shutdown".

If I do a backup and restore of the DB the problem appears to correct 
itself. Any ideas?

Script Sample:
CREATE ROLE FULLACCESS;
COMMIT;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACCTCUSTOMERS TO 
FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITY TO FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYASSIGNMENT TO 
FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYDEPARTMENT TO 
FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYDOCUMENTS TO 
FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYITEM TO 
FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYPAYABLE TO 
FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYRULES TO 
FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYTEMPLATE TO 
FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYTEMPLATECATEGORY 
TO FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYTEMPLATERULES TO 
FULL_ACCESS;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ACTIVITYUNITCOST TO 
FULL_ACCESS;
COMMIT;
GRANT EXECUTE ON PROCEDURE ACCTCUSTOMERSGENPRIME TO FULL_ACCESS;
GRANT EXECUTE ON PROCEDURE ACTIVITYGENPRIME TO FULL_ACCESS;
GRANT EXECUTE ON PROCEDURE ACTIVITYPAYABLEGENPRIME TO FULL_ACCESS;
GRANT EXECUTE ON PROCEDURE ACTIVITYTEMPLATECATGENPRIME TO FULL_ACCESS;
GRANT EXECUTE ON PROCEDURE ACTIVITYTEMPLATEGENPRIME TO FULL_ACCESS;
GRANT EXECUTE ON PROCEDURE ACTTEMPLATERULESGENPRIME TO FULL_ACCESS;
COMMIT;
GRANT FULL_ACCESS TO CHRONICLE;
COMMIT;
Technical Details
Message-ID: <44281c24$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,352ba8ed31565391,start
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Todd" <todd7@hotmail.com>
From: "Todd" <todd7@hotmail.com>
Newsgroups: borland.public.interbase.opensource
Subject: Updating IB6 metdata with IBConsole using a script.
Date: Mon, 27 Mar 2006 12:08:53 -0500
Lines: 51
Organization: Chronicle Technologies Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 69.164.123.33
Message-ID: <44281c24$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1143479332 69.164.123.33 (27 Mar 2006 09:08:52 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail