This is a notification from the Help Desk.

On Mar 07, 2014 @ 03:30 pm, ts@... 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 firebird-support@yahoogroups.com, 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, patrick_marten@... 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 firebird-support@yahoogroups.com, 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]