[firebird-support] Re: Roles - Permissions - RDB$ADMIN
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 not a role. Did you try the GRANTED BY clause in REVOKE? Dmitry
RE: [firebird-support] Re: Roles - Permissions - RDB$ADMIN
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 not a role. Did you try the GRANTED BY clause in REVOKE? Dmitry 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 some non SYSDBA user. Surely? Alan
Re: [firebird-support] Vietnamese characters in Firebird
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 ASCII NOT NULL, EMAIL VARCHAR(100) CHARACTER SET ASCII,FACE VARCHAR(100) CHARACTER SET UTF8, PRIMARY KEY (MASV)); | When i type Vietnamese character into Column TenSV, the result cannot show the right character, it only shows the ? character for some special Vietnamese character (ex: ? for ể). I changed the character set to WIN1258 but the problem cannot be solved. What should i do to store the correct character? Thanks a lot for any help. :D As I also posted on stackoverflow: The character (ể) is unicode codepoint U+1EC3, which is not part of [WIN1258][1], and therefor won't be stored (or displayed) using WIN1258. Make sure you use UTF8 for both your connection characterset, database/column characterset and that the application, console or whatever you use for display also supports this character. [1]: http://msdn.microsoft.com/en-us/goglobal/cc305151.aspx -- Mark Rotteveel
[firebird-support] Re: Roles - Permissions - RDB$ADMIN
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 some non SYSDBA user. Surely? AFAIR, SYSDBA cannot do it either. Or better say he can but the grantor must be known in advance. This is more or less by design, although I don't know whether it's required by the SQL spec or not. Dmitry
Re: [firebird-support] RE: Full Cross Tab but unknown column headers
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 tried the one from your web page as well as the one you sent me as a download) I get the error: Executing statement... Error: *** IBPP::SQLException *** Context: Statement::Execute( CREATE PROCEDURE ACTUALIZAR_TABLA_PIVOT( tcTablaPivot VARCHAR( 28), tcVista VARCHAR( 28), tcPr... ... ...STATEMENT lcActualizar; END END END ) Message: isc_dsql_execute2 failed SQL Message : -607 This operation is not defined for system tables. Engine Code: 335544351 Engine Message : unsuccessful metadata update STORE RDB$PROCEDURES failed Malformed string Total execution time: 0.015s Surprisingly I was able to create this SP well in FB 2.1.4! Please advise. Thanks and regards Bhavbhuti
[firebird-support] Can a Firebird database be hosted on a hosting site?
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 site, and we plan to have a website so that we can access our database from one branch to another. I tried searching for providers which can host my database, but failed to find one. I was also thinking of hosting it on our own server but don't know where to start also. Thank you very much.
Re: [firebird-support] Can a Firebird database be hosted on a hosting site?
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 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 site, and we plan to have a website so that we can access our database from one branch to another. I tried searching for providers which can host my database, but failed to find one. I was also thinking of hosting it on our own server but don't know where to start also. Thank you very much.
Re: [firebird-support] Can a Firebird database be hosted on a hosting site?
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 connected via lan. As our company grows, so its needs. We plan to expand on another branch which will be located on a different site, and we plan to have a website so that we can access our database from one branch to another. I tried searching for providers which can host my database, but failed to find one. I was also thinking of hosting it on our own server but don't know where to start also. Thank you very much.
SV: [firebird-support] RE: Full Cross Tab but unknown column headers
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( EXECUTE BLOCK returns (Mystatement varchar(1)) AS DECLARE VARIABLE S VARCHAR(256) ) Message: isc_dsql_prepare failed SQL Message : -104 Invalid token Engine Code: 335544569 Engine Message : Dynamic SQL Error SQL error code = -104 Unexpected end of command - line 2, column 31 Total execution time: 0.015s Seems like whatever components you use, thinks that the first semicolon terminates the statement, even if it is within EXECUTE BLOCK. Maybe you need to write SET TERM ^^ ; before EXECUTE BLOCK and then terminate the EXECUTE BLOCK with ^^ and have SET TERM ; ^^ at the end. But I'm just guessing, I've no such problems with IB Workbench. I expect the database to be DIALECT 3 and not an old database still in DIALECT 1? So as per your advice I changed it to CREATE PROCEDURE and created an SP called MyProc then I used the command SELECT * FROM MyProc and I do get a string back (BTW I had to increase 4096 to 1 else got an overflow) Now I can execute the string if I copy and paste it, but is there any way to directly execute the string returned from the SELECT * FROM MyProc? In a program, this is of course very simple, just add the result to a cursor or query component and open it. In a stored procedure, you can use EXECUTE STATEMENT, but the problem is that to return the rows from the stored procedure to the user, you need to know the name, type and (maximum) number of columns when you create the procedure, and this is what we try to avoid. Hence, I would recommend to return the statement to the caller (a program or similar) and let the caller thereafter call what is returned. Set
Re: [firebird-support] Can a Firebird database be hosted on a hosting site?
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 monteagudo dice_in_trou...@yahoo.com wrote: Thanks to all those replied. I was just wondering what interface are you using when accessing data from a web host? We are currently running a interface built on delphi 7 with zeos as its component. Will it work? Thanks On Sunday, January 5, 2014 2:41 AM, W O sistemas2000profesio...@gmail.com wrote: 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 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 site, and we plan to have a website so that we can access our database from one branch to another. I tried searching for providers which can host my database, but failed to find one. I was also thinking of hosting it on our own server but don't know where to start also. Thank you very much.