To modify table privileges I would like to see the following behavior:

1) To apply the modifications it is necessary to press Ok. If you
change the user or role before Ok you loose the modifications. It would
be good to have an APPLY button.

2) If you change the privileges of a role it would good to see the
results in the according users also.

3) It is easier to have different dialogs or 2 lookups for role and
user.

Regards Karlheinz

Karl,

<< 1) To apply the modifications it is necessary to press Ok. If you change
the user or role before Ok you loose the modifications. It would be good to
have an APPLY button. >>

Noted.

<< 2) If you change the privileges of a role it would good to see the
results in the according users also. >>

If you're logged in as a non-administrator, then you will see the
"effective" privileges.  However, if you're logged in as an administrator,
then you will see only the privileges specifically granted to a particular
user or role.  IOW, to see the effective privileges for a user, just log in
as that user in the EDB Manager.  You can also find out the effective
privileges on a given object with a query like this:

SELECT *
FROM DatabasePrivileges INNER JOIN
(SELECT Name FROM Users WHERE Name='Administrator'
UNION ALL
SELECT Name FROM UserRoles WHERE GrantedTo='Administrator') Authorizations
ON DatabasePrivileges.GrantedTo=Authorizations.Name

Note that you have to use constants and not parameters for the user name in
the derived table (Authorizations).

<< 3) It is easier to have different dialogs or 2 lookups for role and user.
>>

They are all considered "authorizations" under the SQL 2003 model, which is
why there is not distinction between the two in terms of privileges and
privilege assignments.

--
Tim Young
Elevate Software
www.elevatesoft.com