Article View: borland.public.interbase.opensource
Article #12Updating IB6 metdata with IBConsole using a script.
From: Todd
Date: Mon, 27 Mar 2006 17:08
Date: Mon, 27 Mar 2006 17:08
48 lines
2986 bytes
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-mailShow 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