send me a copy of this DB offline
Alan

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]On Behalf Of bookie05dad
> Sent: Tuesday, 22 May 2007 2:11 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: I can't get roles to work...
>
>
> Actually there are exactly two things in the database: the test_table
> and the tooluser role. I even dropped and rebuilt the database and
> reinstalled the security database -- still no luck...
>
> Mike...
>
> --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
> > > >
> > > > grant ROLE tooluser to BOBJOHN
> >
> > I never use this syntax!
> >
> > CREATE ROLE ROLENAME;
> > GRANT ALL ON TABLENAME TO ROLENAME;
> > GRANT ROLENAME TO USERNAME;
> >
> > if this is not doing as you ssupect, then I suspectc you already have
> > another object in your schema with a rolename or username.
> > Alan
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>