> --- 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

sorry - thought that was your sql - it was helen's
that's correct - just make sure the user logs on with that role
Alan