[firebird-support] How to retrieve list of users granted with the admin role

2014-06-18 Thread r...@xs4all.nl [firebird-support]
As SYSDBA I like to know which users are granted in the past with the ADMIN ROLE (as in CREATE USER Test1 PASSWORD 'test' GRANT ADMIN ROLE). I guess those users have the system defined RDB$ADMIN role assigned in the security database, but I do not have direct access to the security databae

[firebird-support] Windows Server 2012 with Firebird 2.5.2 64-bit

2014-06-18 Thread mniel...@whittoncompanies.com [firebird-support]
I recently purchased new top of the line hardware to host a new Firebird server on Windows 2012 server utilizing Hyper-V. After building the hardware and OS I installed Firebird 2.5.2 64 bit and installed the classic version. I ran some tests and the a simple test caused the Firebird

RE: [firebird-support] Windows Server 2012 with Firebird 2.5.2 64-bit

2014-06-18 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
I recently purchased new top of the line hardware to host a new Firebird server on Windows 2012 server utilizing Hyper-V. After building the hardware and OS I installed Firebird 2.5.2 64 bit and installed the classic version.  I ran some tests and the a simple test caused the Firebird

[firebird-support] File dbxconnections.ini for Firebird

2014-06-18 Thread assisinformat...@gmail.com [firebird-support]
Delphi XE3 DBX Firebird In file dbxconnections.ini driver Firebird, What is the correct way? dbxconnections.ini [dbfirebird] DriverName=Firebird BlobSize=-1 or MaxBlobSize=-1 TrimChar=False or Trim Char=False Role= or RoleName= -- Paulo

[firebird-support] RDB$GET_CONTEXT performance vs PK lookup query

2014-06-18 Thread s3057...@yahoo.com [firebird-support]
Hello Group, I am looking at a situation where lots of different stored procedures need to execute an alternate query where a certain condition is true in the database. I would normally do something along the lines IF (EXISTS(SELECT 1 FROM CONFIG WHERE CONFIGID = 1234 AND VALUE=1)) THEN BEGIN

Re: [firebird-support] How to retrieve list of users granted with the admin role

2014-06-18 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Hi Robert, roles are database specific. Check RDB$ROLES and RDB$USER_PRIVILEGES, you'll probably find out what you need - if not, come back and ask, I'll dig in more details. Thomas Am 18.06.2014 15:23, schrieb r...@xs4all.nl [firebird-support]: As SYSDBA I like to know which users are