Hi Philippe,

Thank you for responding to my question.

So what you are saying, it is better to use ISQL than GSEC to create Roles and set privileges on tables?

Good, this is what I will do. I did not feel comfortable with GSEC anyways; there is little documentation and ISQL is more SQL'ish, which I feel more at ease with than GSEC.

Again, thank you for your input.

Regards,
Michael

--- In firebird-support@yahoogroups.com, philippe makowski <pmakowski@...> wrote:
>
> mpp12310 [2012-03-27 17:04] :
> > Hi,
> >
> > I am running FB 2.1.4 on Ubuntu 10.04 LTS server.
> >
> > From the server command prompt, I am able to login to GSEC, attached to my database. When I issue the following GSEC command I get an error:
> >
> > gsec> CREATE ROLE SDB_ADMIN (with or without ;)
> >
> > error message:
> >
> > invalid switch specified
> > error in switch specifications
> >
> > Can anyone please tell what I am doing wrong?
> >
> you don't have to create role with gsec
>
> http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gsec.html
>
> read for example this :
> http://www.firebirdsql.org/file/documentation/papers_presentations/html/paper-fb-macosx-getstart.html
>
> and this :
> http://www.slideshare.net/ibsurgeon/firebird-security-in-english-the-past-and-the-future
>