| Subject | Re: [Firebird-Java] Data Source vs. SQL Role |
|---|---|
| Author | Steven Jardine |
| Post date | 2005-01-18T02:24:47Z |
Wyvis,
GRANT ALL TO ROLENAME;
GRANT ROLENAME TO USERNAME;
A more detailed explanation can be found in the langref.pdf (pages 123-126) document found in the firebird documents.
Steve
>Does anyone know how I specify the SQL role to use for the user? IYou should use the grant statement. For example,
>tried setting a config-property of "SqlRole" but that didn't work.
>
>
GRANT ALL TO ROLENAME;
GRANT ROLENAME TO USERNAME;
A more detailed explanation can be found in the langref.pdf (pages 123-126) document found in the firebird documents.
Steve