--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > > This is what you would do to use the role cm_logs:
> > > SQL>set auto on;
> > > SQL>create role cm_logs;
> > > SQL> grant all on cm_logs to full_access;
> > > SQL> grant cm_logs to dbUser;
> > >
> > > After granting the role to the user, the user then logs in using
> > both his
> > > user name and password and the role. Then your login parameters
> > would work.
> > >
> > > ./heLen
> >
> > I'm a bit confused that you've called the role cm_logs (that's the
> > name of the table - is that deliberate?).
>
> if you look at the SQL above you have created a role cm_logs
>
> Alan

which is why I'm confused.

I have a table called cm_logs and a user called dbUser.
I wanted a role called full_access which dbUser could use to gain
insert permissions etc.

wouldn't it be;

SQL> create role full_access;
SQL> grant all on cm_logs to full_access;
SQL> grant full_access to dbUser;

?

I was assuming using cm_logs earlier was a typo, but since things
still aren't working for me I'd like to check...

nik