[firebird-support] Re: Roles - Permissions - RDB$ADMIN

2014-01-04 Thread Dmitry Yemanov
04.01.2014 11:51, Alan McDonald wrote: Users with RDB$ADMIN granted to them have the ability to creates users. They can, of course, also grant other roles to users. But they cannot revoke roles already granted to a user by another RDB$ADMIN or SYSDBA since the RDB$GRANTOR is always a user

RE: [firebird-support] Re: Roles - Permissions - RDB$ADMIN

2014-01-04 Thread Alan McDonald
04.01.2014 11:51, Alan McDonald wrote: Users with RDB$ADMIN granted to them have the ability to creates users. They can, of course, also grant other roles to users. But they cannot revoke roles already granted to a user by another RDB$ADMIN or SYSDBA since the RDB$GRANTOR is always

Re: [firebird-support] Vietnamese characters in Firebird

2014-01-04 Thread Mark Rotteveel
On 4-1-2014 03:57, quanpha...@gmail.com wrote: I created a table in Firebird 2.5 with the following code: |CREATE TABLE DMSV (MASV CHAR(8) CHARACTER SET ASCII NOT NULL, TENSV VARCHAR(120) CHARACTER SET UTF8 NOT NULL, LOP CHAR(10) CHARACTER SET ASCII NOT NULL, SDT VARCHAR(11)CHARACTER SET

[firebird-support] Re: Roles - Permissions - RDB$ADMIN

2014-01-04 Thread Dmitry Yemanov
04.01.2014 14:03, Alan McDonald wrote: That may work but it doesn't seem right that we have to query the grantor before an RDB$ADMIN can issue the command. RDB$ADMIN, I thought, in theory, was to be equal in all things to SYSDBA, and SYSDBA should also be able to override a grant granted by

Re: [firebird-support] RE: Full Cross Tab but unknown column headers

2014-01-04 Thread W O
Do you have the SET TERM? Greetings. Walter. On Sat, Jan 4, 2014 at 2:41 AM, venussof...@gmail.com wrote: Hi Walter Okay I upgraded to FB 2.5.2.26540. I have successfully created the SPs Parser and Crear_Tabla_Pivot but when I try to create the SP called ACTUALIZAR_TABLA_PIVOT (I

[firebird-support] Can a Firebird database be hosted on a hosting site?

2014-01-04 Thread dice_in_trouble
Hello to all, I would like to host my firebird database on a provider, but don't have an idea on where to start. We currently have a firebird database in which is connected via lan. As our company grows, so its needs. We plan to expand on another branch which will be located on a different

Re: [firebird-support] Can a Firebird database be hosted on a hosting site?

2014-01-04 Thread W O
We had used www.inspirohost.com the last year with good results. Greetings. Walter. On Sat, Jan 4, 2014 at 2:22 PM, dice_in_trou...@yahoo.com wrote: Hello to all, I would like to host my firebird database on a provider, but don't have an idea on where to start. We currently have a

Re: [firebird-support] Can a Firebird database be hosted on a hosting site?

2014-01-04 Thread Alexey Kovyazin
Hi, Rent VPS or dedicated server and install there all you need (including Firebird). Regards, Alexey Kovyazin IBSurgeon Hello to all, I would like to host my firebird database on a provider, but don't have an idea on where to start. We currently have a firebird database in which is

SV: [firebird-support] RE: Full Cross Tab but unknown column headers

2014-01-04 Thread Svein Erling Tysvær
Hi Set I just upgraded to FB 2.5.2.26540 and tried the EXECUTE BLOCK again but had the same issues: Starting transaction... Preparing statement: EXECUTE BLOCK returns (Mystatement varchar(1)) AS DECLARE VARIABLE S VARCHAR(256) Error: *** IBPP::SQLException *** Context: Statement::Prepare(

Re: [firebird-support] Can a Firebird database be hosted on a hosting site?

2014-01-04 Thread W O
Yes, if you can have access to a local database then you can have access to a remote database. Just write the connection string. In the case of inspirohost they give you an user name, a password and that user have the RDB$ADMIN role. Greetings. Walter. On Sat, Jan 4, 2014 at 4:54 PM, cedriz