I am not sure what the problem is, but SAPDB 7.4 does not seem to work as described in documentation. Default role set on a usergroup is not activated when a user from the group connects to DB. Here is a sample script for the problematic configuration. Issuing SET ROLE ALL after the connection is established sets everything in place, but my impression from SAPDB docs is that this should be done automaticly.
CREATE TABLE TEST ( ID FIXED(10) DEFAULT SERIAL PRIMARY KEY, DATA VARCHAR(100) ) // CREATE ROLE TR // GRANT SELECT ON TEST TO TR // CREATE USERGROUP TUG STANDARD NOT EXCLUSIVE // GRANT TR TO TUG // CREATE USER TU PASSWORD TU USERGROUP TUG // ALTER USERGROUP TUG DEFAULT ROLE ALL // ---------------------------- Kostadin Bajalcaliev Eureka Informatika [EMAIL PROTECTED] ---------------------------- -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
