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