[firebird-support] Firebird Security Authentication Configuration Questions

Hi All, I am wondering about the level of support in Firebird's implementation of Win_Sspi as I can not find specific documentation. If anyone can point me to a source document I would greatly appreciate it. The situation I have is a heterogeneous mixture of platforms within a corporate

[firebird-support] Re: Select Distinct returning multiple rows

. From: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com> on behalf of Dalton Calford dcalf...@distributel.ca [firebird-support] <firebird-support@yahoogroups.com> Sent: December 11, 2017 2:37:39 PM To: firebird-support@yahoogroups

Re: [firebird-support] Triggers - One big or more smaller?

I prefer more smaller triggers with a specified firing order, along with code at the beginning of the trigger that checks to see if the trigger should fire or not - this allows you to disable a trigger within the scope of a single transaction ie. (a) Update master table that trigger checks -

Re: [firebird-support] Digest Number 9396

Yes, But the new domain is not created for every table, just for every column where you are not using a pre-defined domain. So, Create table MYTABLE(mycolA integer, mycolB integer, mycolC integer); would auto create three separate new domains. I wish I knew more of what you are trying to

Re: [firebird-support] Digest Number 9396

Every time you do not define a domain when creating a column in a table, firebird creates a new domain.Unless they have changed something fundamental, they never purge unused domains. So, you perform a backup and it recreates all the prior domains first, then, proceeds to create new

Re: [firebird-support] Digest Number 9396

Interesting, only one record. The RDB$ domains are auto generated by the system - RDB$1297080260861 says that it is the 1,297,080,260,861 domain created by the system. If this is not the only auto-generating domain you have been using, it is possible that you have hit the maximum

Re: [firebird-support] Digest Number 9396

That type of error generally is caused by a utility or process that has changed the definition of the column. You have data in your column in that table that no longer fits in the new definition. When you manually change, or use a utility to smack the system tables, vs creating a whole new

[firebird-support] Unix ODBC with Firebird ODBC and ODBC Manager

I am having difficulties with the latest linux Firebird 64 bit ODBC drivers in that they are not working with the latest UnixODBC versions. When using the ODBC Administrator, (unixODBC-GUI-Qt4) it tells me it can not load a property list for Firebird. Does anyone have a setup guide for ODBC

Re: [firebird-support] Looking for detailed documentation on the new Firebird 3 security authentication process.

Hi Alain, For roles and trusted authentication (which is what I am discussing here) you use the "set trusted role" command. With trusted authentication (when you use the OS/network to authenticate the user) you are not passing role information and the dba needs to apply trusted roles which

Re: [firebird-support] How non-SYSDBA user can see connections by other users?

You have a few choices in how to do this. You can either upgrade your users to RDB$ADMIN role rights (not recommended) or you can grant the user to have rights to a view that gets it's data from a stored procedure that connects back to the database in a separate connect/transaction as a user

Re: [firebird-support] Looking for detailed documentation on the new Firebird 3 security authentication process.

Hi Alain, We use full user authentication at our company, so everyone logs into the database using their own credentials. Currently, each user has an account in the firebird security database. Each user also has a windows domain account. This means each user has, at a minimum, two

[firebird-support] Looking for detailed documentation on the new Firebird 3 security authentication process.

Hi Everyone. I have a linux machine (Ubuntu 16.04 64bit Server) with Firebird 3.01 64 bit installed. That machine is a member of our corporate domain and authenticates via PAM/Samba4 for all user access. I want to have Firebird client applications on remote windows machines to use the

[firebird-support] Detailed information in regards to Trusted Authentication

Hi, I am testing Firebird 3 and one of the tests happens to be finding out if it supports Active Directory. I am assuming that trusted user authentication passes the user identity as per the local machine to the server. The question I have is how you would setup a linux box (already part

Re: [firebird-support] Re: Firebird 3 on Kubuntu 16.04

Thanks, I removed Firebird and tried the downloads from Sourceforge, all is working fine now. From: firebird-support@yahoogroups.com on behalf of peshk...@mail.ru [firebird-support] Sent:

[firebird-support] Firebird 3 on Kubuntu 16.04

Hey All, Does anyone have the latest install guides for Firebird 3 on systemd based Ubuntu systems? I installed firebird, gave it the password but the install had output as follows Created default security3.fdb Failed to start firebird3.0-server.service: Unit firebird3.0-server.service not

[firebird-support] Newer null sort order and legacy Applications

I have an cluster of older database formats (32bit firebird 1.5) and I wish to see about migrating them to a newer firebird 2.5 64 bit format. We replicate using older custom C code on telco servers, so redesigning the replication code and getting it certified for use is a non-starter. So,

[firebird-support] Setting up FreeAdhocUDF on an Ubuntu Server

I am attempting to setup FreeAdhocUDF on a standard (apt-get) install of firebird 2.5 The server is a 64 bit machine/OS/firebird install. I am having problems understanding some of the FreeAdhocUDF documentation For example, the documentation assumes that firebird is installed under /opt/ and

[firebird-support] Getting a list of system users via SQL

With firebird 2.5 we received some wonderful tools that allowed us to create, update and drop users without needlessly mucking about with smacking the security database. Yea! But, we also where locked out from reading the security database so we can no longer see who is defined in the

RE: [firebird-support] Re: Getting a list of system users via SQL

Is there a method to remove the restriction on connecting to security2.fdb until fb3 goes gold? From: firebird-support@yahoogroups.com [firebird-support@yahoogroups.com] Sent: 01 September 2015 11:01 To: firebird-support@yahoogroups.com Subject:

[firebird-support] Firebird 2.5.2.26540 superclassic on Ubuntu 14.04 LTS Server

Hi Everyone, I am almost embarrassed to ask, but, I am having a great deal of difficulty with setting this up. I have a brand new installation of Ubuntu LTS Server 14.04 I have installed firebird superclassic. I have used gbak to restore a database without any problems I can connect to my