Thread View: borland.public.interbase.opensource
4 messages
4 total messages
Started by Todd
Mon, 27 Mar 2006 17:08
Updating IB6 metdata with IBConsole using a script.
Author: 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;
Re: Updating IB6 metdata with IBConsole using a script.
Author: Bill Todd
Date: Mon, 27 Mar 2006 20:27
Date: Mon, 27 Mar 2006 20:27
10 lines
1180 bytes
1180 bytes
Todd wrote: > with exclusivity. If "with exclusivity" means that you shutdown the database then you must restart it using gfix or IBConsole before any user but sysdba or the database owner can log in. -- Bill Todd (TeamB)
Re: Updating IB6 metdata with IBConsole using a script.
Author: Todd
Date: Mon, 27 Mar 2006 22:19
Date: Mon, 27 Mar 2006 22:19
22 lines
1609 bytes
1609 bytes
Bill, I believe it is the restart portion I am missing, Am I correct to use gfix -online to start from the commandline. How do I restart the database in IBConsole? Thanks for your help. Nice last name BTW. Todd "Bill Todd" <no@no.com> wrote in message news:442858c2$1@newsgroups.borland.com... > Todd wrote: > >> with exclusivity. > > If "with exclusivity" means that you shutdown the database then you > must restart it using gfix or IBConsole before any user but sysdba or > the database owner can log in. > > -- > Bill Todd (TeamB)
Re: Updating IB6 metdata with IBConsole using a script.
Author: Bill Todd
Date: Tue, 28 Mar 2006 00:36
Date: Tue, 28 Mar 2006 00:36
14 lines
1289 bytes
1289 bytes
Todd wrote: > I believe it is the restart portion I am missing, > Am I correct to use gfix -online to start from the commandline. Yes. > How do I restart the database in IBConsole? Select the database in the treeview then choose Database | Maintenance | Database Restart from the menu. -- Bill Todd (TeamB)
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads