This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:30 pm, [email protected] wrote: > creation of a ODBC connection to an embedded server works with SYSDBA only, > is that correct? I was not able to create one with another user. No. You should be able to connect with a different user as well. It might fail for some reason because the specified user doesn't have sufficient privileges on database objects ... > If that's not correct: > what can be the reason for the problem I have when trying to create a > connection with a different user. Don't know without telling us the error message you get. > If that's correct: > the only way would be to grant SYSDBA read only rights, correct? Is that > possible at all? No. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ > --- In [email protected], Thomas Steinmaurer<ts@...> wrote: >> >>> how can I get Firebird ODBC driver to connect to an embedded server by >>> using the security2.fdb? >>> >>> Is there any reason, why the security2.fdb is being ignored in that case at >>> least by default? >>> >>> That way the ODBC connection can only be created with SYSDBA as user and >>> there is no way to make the connection read only. I mean yes, you can check >>> the checkbox "read" when creating the connection, but the end user can >>> uncheck it at any time and gat a write access to the DB... >>> >>> For the ODBC connection to a normal server he could do the same of course, >>> but since in that case the connection cen be created with a user, who has >>> read rights only, it doesn't matter if the checkbox gets unchecked. >>> >>> Why can't it work the same with embedded server? That doesn't make sense to >>> me... Can I accomplish it in any way? >> >> Embedded works that way: The provided user/password combination isn't >> checked against the security database, but SQL privileges are checked >> for the provided user when it comes to accessing tables, views etc ... >> >> >> -- >> With regards, >> Thomas Steinmaurer >> >> * Upscene Productions - Database Tools for Developers >> http://www.upscene.com/ >> >> * My Blog >> http://blog.upscene.com/thomas/index.php >> >> * Firebird Foundation Committee Member >> http://www.firebirdsql.org/en/firebird-foundation/ >> > > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > ==Ticket History== On Mar 07, 2014 @ 03:30 pm, [email protected] wrote: Thanks for your reply, creation of a ODBC connection to an embedded server works with SYSDBA only, is that correct? I was not able to create one with another user. If that's not correct: what can be the reason for the problem I have when trying to create a connection with a different user. If that's correct: the only way would be to grant SYSDBA read only rights, correct? Is that possible at all? --- In [email protected], Thomas Steinmaurer <ts@...> wrote: > > > how can I get Firebird ODBC driver to connect to an embedded server by > > using the security2.fdb? > > > > Is there any reason, why the security2.fdb is being ignored in that case at > > least by default? > > > > That way the ODBC connection can only be created with SYSDBA as user and > > there is no way to make the connection read only. I mean yes, you can check > > the checkbox "read" when creating the connection, but the end user can > > uncheck it at any time and gat a write access to the DB... > > > > For the ODBC connection to a normal server he could do the same of course, > > but since in that case the connection cen be created with a user, who has > > read rights only, it doesn't matter if the checkbox gets unchecked. > > > > Why can't it work the same with embedded server? That doesn't make sense to > > me... Can I accomplish it in any way? > > Embedded works that way: The provided user/password combination isn't > checked against the security database, but SQL privileges are checked > for the provided user when it comes to accessing tables, views etc ... > > > -- > With regards, > Thomas Steinmaurer > > * Upscene Productions - Database Tools for Developers > http://www.upscene.com/ > > * My Blog > http://blog.upscene.com/thomas/index.php > > * Firebird Foundation Committee Member > http://www.firebirdsql.org/en/firebird-foundation/ > ------ This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/290 [Non-text portions of this message have been removed]
