🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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.
#12
Author: 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;
Re: Updating IB6 metdata with IBConsole using a script.
#13
Author: Bill Todd
Date: Mon, 27 Mar 2006 20:27
10 lines
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.
#14
Author: Todd
Date: Mon, 27 Mar 2006 22:19
22 lines
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.
#16
Author: Bill Todd
Date: Tue, 28 Mar 2006 00:36
14 lines
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