I just noticed that roles are case sensitive when they are created quoted, is that correct behavior?
I have noticed several problems with this: 1) With Jaybird I am unable to use the role "userrights2" (a role userrights or USERRIGHTS works fine. Maybe Jaybird is adding the rolename dpb item incorrectly (as it does work for isql). I have tried double quotes and single quotes. 2) Doing a GRANT .. ON .. TO userrights2 will assign rights to the *user* USERRIGHTS2, while GRANT .. ON .. TO "userrights2" will assign it to the *role* "userrights2" (which is inconsistent and slightly annoying). Maybe GRANT should require that the object type is always specified, or a missing object type always implies USER and never ROLE (or another object type). 3) In isql SHOW GRANTS does not correctly quote case sensitive objectnames (but it also does this for other object names like tables). Mark -- Mark Rotteveel ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
