the role is included in the string.

The strange thing about this is I can view data in the table using the
odbc driver and msquery. I can not see the data using the .net driver
or if I use a graphic based tools such as ibeasy or iboconsole.

--- In firebird-support@yahoogroups.com, Sam Hunt <shunt@n...> wrote:
> 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.