Search found 7 matches

by dve83
11.07.2012, 07:33
Forum: Firebird
Topic: Firebird Security DB and Users Table
Replies: 9
Views: 7392

awsome. I will take a look and let you know.
by dve83
11.07.2012, 06:01
Forum: Firebird
Topic: Firebird Security DB and Users Table
Replies: 9
Views: 7392

thank you though. For any other input, herewith what I received from the firebird mailing list at yahoo. It seems I need access to the Services API. Is this available? If not, is there a workaround OR could you direct me to the correct API calls in the PAS units. >Hello, > >I thank you for the reply...
by dve83
10.07.2012, 20:58
Forum: Firebird
Topic: Firebird Security DB and Users Table
Replies: 9
Views: 7392

Hi again, thanks again for the reply. The USER_PRIVILEGES table contains roles / privileges assigned to existing users. I think what Im looking for is the table containing the users only (even before I've assigned any roles to it). As far as I can understand, this resides in the Security2.fdb. My re...
by dve83
10.07.2012, 15:00
Forum: Firebird
Topic: Firebird Security DB and Users Table
Replies: 9
Views: 7392

Hi, thanks for the reply. Im assuming I can be logged on to any database (as long as its with the dbadmin account)? Perhaps Im just being dumb: I get the following error --------------------------- ptest --------------------------- SQL Error: Dynamic SQL Error SQL error code = -204 Table unknown RDB...
by dve83
10.07.2012, 14:11
Forum: Firebird
Topic: Firebird Security DB and Users Table
Replies: 9
Views: 7392

Firebird Security DB and Users Table

Hello, Im still in my 'infant' stages with zeoslib and firebird db. I am attempting to allow my application to connect to the Security Database (in some way or the other) with an Administrative account: My purpose is to select from the USERS table to determine available database users. I also wish t...
by dve83
22.04.2012, 20:04
Forum: Firebird
Topic: Delphi & Firebird and Create Database
Replies: 4
Views: 7202

hi and thank you for the quick reply. Yes, kind of got to the same conclusion (try and except - im testing for error -904 - invalid database handle) ive tried to do some homework on the source, but couldn't find any quick access to the "open" function. I figure I could inherited from TZAbs...
by dve83
22.04.2012, 18:41
Forum: Firebird
Topic: Delphi & Firebird and Create Database
Replies: 4
Views: 7202

Delphi & Firebird and Create Database

Hi guys, tried searching through the forum and other places but havewnt been able to answer this questions. I'm trying to connect to a Firebird (32bit) database through ZeosLib. Basic code looks like this (notice the commented code); procedure TForm1.FormCreate(Sender: TObject); begin ZConnection1.D...