Subject Re: [firebird-support] Re: GSEC error..Invalid Switch
Author 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 SQL statements. Tip: you can run gsec with no arguments to get succinct help output that tersely explains each valid gsec command and the various switches valid for each. Users are server-wide in scope (available to all databases on the server).

Roles and privileges are specific to each user database. You use an SQL interface program, such as isql or one of many third-party client programs to pass CREATE ROLE, GRANT, REVOKE statements to a user database. A role created or a privilege granted is not available to databases other than the one in which it is created.