Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
On 25-06-2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > Is it possible to create databases on a 3.0.5 server with a user other > than sysdba? > when i try in flamerobin create a database with another user it gives me > the following error: > Context:Database::Create > Message:isc_dsql_execute_immediate failed > SQL Message:-551 > This user not have privilege to perform this operation on this object > Engine Code :335544352 > no permission for CREATE access to DATABASE /mnt/ccs/test.fdb See also https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg3-databases.html#qsg3-databases-creating-nonsysdba -- Mark Rotteveel
Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
Thank you, I will follow your instructions. -- Ismael Devuan User: http://distrowatch.com/table.php?distribution=devuan - Original Message - From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" To: Sent: Friday, June 26, 2020 3:34 PM Subject: Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5 > 26.06.2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu > [firebird-support] wrote: >> I don't know if I will be such a novice, but I can't find the language >> reference manual for firebird 3 > > https://firebirdsql.org/en/reference-manuals/ > > Google Translate can help you read it. > > -- > WBR, SD. > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > > ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
On 26-06-2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > I don't know if I will be such a novice, but I can't find the language > reference manual for firebird 3 It is documented in the release notes: https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-access-sql.html#rnfb30-security-metadataprivs PS. Please move this discussion to the new firebird-support list on Googlegroups. -- Mark Rotteveel
Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
26.06.2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > I don't know if I will be such a novice, but I can't find the language > reference manual for firebird 3 https://firebirdsql.org/en/reference-manuals/ Google Translate can help you read it. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
I don't know if I will be such a novice, but I can't find the language reference manual for firebird 3 I install firebird3 in devuan which is the operating system I use and it asks me for the password of the user sysdba. Then if I create the user from flamerobin or using gsec it never lets me use that user that I create to create a new database, that has never happened to me with firebird 2.5.x And the truth is that I have tried in several ways, but the truth did not achieve positive results. Can't someone give me a more detailed explanation of how to create a database in firebird 3 with a user other than sysdba? I know that time is money, but I do not think that it is so much for those who really have the knowledge of how to do it, I have already searched the internet and I have not found it, perhaps it is not possible to search there either. Best regards -- Ismael Devuan User: http://distrowatch.com/table.php?distribution=devuan - Original Message - From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" To: Sent: Thursday, June 25, 2020 3:18 PM Subject: Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5 > 25.06.2020 20:50, 'Ismael L. Donis Garcia' sli...@natio.co.cu > [firebird-support] wrote: >> And how do I assign the pre-benefits to the user that I am going to use >> to >> create the database? > > Using "GRANT" statement as described in Language Reference. > > -- > WBR, SD. > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > > ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
25.06.2020 20:50, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > And how do I assign the pre-benefits to the user that I am going to use to > create the database? Using "GRANT" statement as described in Language Reference. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
And how do I assign the pre-benefits to the user that I am going to use to create the database? Reiterated greetings -- Ismael Devuan User: http://distrowatch.com/table.php?distribution=devuan - Original Message - From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" To: Sent: Thursday, June 25, 2020 11:07 AM Subject: Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5 > 25.06.2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu > [firebird-support] wrote: >> Is it possible to open database 2.5.9 on servers 3.0.5? > > No. > >> Is it possible to create databases on a 3.0.5 server with a user other >> than sysdba? > > Yes, but appropriate privilege must be granted to the user. > > Actually it is plainly written in the error messages. > > -- > WBR, SD. > > ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
You have sent your email to the old list, please post to the new list at firebird-supp...@googlegroups.com (or https://groups.google.com/d/forum/firebird-support). If you're not subscribed yet, you can do it on above link, or by sending an email to firebird-support+subscr...@googlegroups.com (if your email address is not associated with a Google account, make sure to confirm by replying to the email). Mark On 2020-06-25 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > Is it possible to open database 2.5.9 on servers 3.0.5? > > when I try to open it with flamerobin it gives me the following error: > > Context:Database::Connect > Message:isc_attach_database failed > > SQL Message:-820 > wrong or obsolete version > > Engine Code :335544379 > Engine Message: > unsupported on-disk structure for file /mnt/ccs/libsc.fdb; found 11.2, > support 12.2 > IProvider::attachDatabase failed when loading mapping cache > > Is it possible to create databases on a 3.0.5 server with a user other > than sysdba? > > when i try in flamerobin create a database with another user it gives > me the following error: > Context:Database::Create > Message:isc_dsql_execute_immediate failed > > SQL Message:-551 > This user not have privilege to perform this operation on this object > > Engine Code :335544352 > no permission for CREATE access to DATABASE /mnt/ccs/test.fdb
RE: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
Release Notes "New ODS Number Firebird 3.0 creates databases with an ODS (On-Disk Structure) version of 12. In the initial release, a database with an older ODS cannot be opened by Firebird 3.0. In order to work with a database with an older ODS it will be necessary to make a backup using gbak under the older server and restore it with gbak on Firebird 3. Note A legacy provider for databases with ODS 8 to 11.2 is planned for a future sub-release" Paul -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 25 June 2020 16:46 To: Firebird Support Subject: [firebird-support] error when trying to open databases 2.5 on server 3.0.5 Is it possible to open database 2.5.9 on servers 3.0.5? when I try to open it with flamerobin it gives me the following error: Context:Database::Connect Message:isc_attach_database failed SQL Message:-820 wrong or obsolete version Engine Code :335544379 Engine Message: unsupported on-disk structure for file /mnt/ccs/libsc.fdb; found 11.2, support 12.2 IProvider::attachDatabase failed when loading mapping cache Is it possible to create databases on a 3.0.5 server with a user other than sysdba? when i try in flamerobin create a database with another user it gives me the following error: Context:Database::Create Message:isc_dsql_execute_immediate failed SQL Message:-551 This user not have privilege to perform this operation on this object Engine Code :335544352 no permission for CREATE access to DATABASE /mnt/ccs/test.fdb Best Regards -- Ismael Devuan User: http://distrowatch.com/table.php?distribution=devuan
Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5
25.06.2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > Is it possible to open database 2.5.9 on servers 3.0.5? No. > Is it possible to create databases on a 3.0.5 server with a user other than > sysdba? Yes, but appropriate privilege must be granted to the user. Actually it is plainly written in the error messages. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/