Fr. Robert Bower wrote:

>I've created a database using the default sysdba user.
>
>I've created a role and a user and added the user to the role.
>
>I have also assigned rights to the role for tables, views, and
>procedures.
>
>The problem is I can not see any any data in the tables whether I
>connect through the .net driver or use a gui tool with the user I
>created. I can only see information if I use the sysdba account.
>
>Any Ideas?
>
>Thanks
>
>Fr. Robert
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
>

Since the role has the priviledges and not the user, my limited
experience has taught me that, when a user is assigned to a role, you
must define the role in the connection.
i.e: connectionString: Role=myrole;
Sam H.