Re: [firebird-support] Re: GSEC error..Invalid Switch

2012-03-28 Thread Norman Dunbar
Evening Michael, > No offense was intended..as you said, there is never enough documentation. Oh dear, my sense of humour gets me in trouble again! There was never any offence taken, trust me, I'm not one to be offended by anything, and I certainly wasn't having a go at you either. I apologise

[firebird-support] Re: GSEC error..Invalid Switch

2012-03-28 Thread mpp12310
Hi Norm, No offense was intended..as you said, there is never enough documentation. With respect, Michael --- In firebird-support@yahoogroups.com, Norman Dunbar wrote: > > Morning Michael, > > > On 27/03/12 20:06, mpp12310 wrote: > > So what you are saying, it is better to use ISQL than GSEC

Re: [firebird-support] Re: GSEC error..Invalid Switch

2012-03-28 Thread Norman Dunbar
Morning Michael, On 27/03/12 20:06, mpp12310 wrote: > So what you are saying, it is better to use ISQL than GSEC to create Roles > and set privileges on tables? Yes, GSEC isn;t for roles, it's for users, server wide. Roles are database specific. There is no ability in gsec to create roles. > G

Re: [firebird-support] Re: GSEC error..Invalid Switch

2012-03-27 Thread Helen Borrie
At 08:06 AM 28/03/2012, mpp12310 wrote: >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? gsec is a utility for maintaining users in the security database. It does not accept S

[firebird-support] Re: GSEC error..Invalid Switch

2012-03-27 Thread mpp12310
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, w

[firebird-support] Re: GSEC error..Invalid Switch

2012-03-27 Thread philippe makowski
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 ;) > >