Subject | RE: [Firebird-Architect] User name SYSDBA |
---|---|
Author | Leyne, Sean |
Post date | 2005-08-03T20:14:22Z |
> Sounds good to me. That way you could delgate the role to anotheruser,
> let him do the work, and actually find out who is doing what (rightnow
> if anything signfiicant gets done, it's done by SYSDA, which isn'tvery
> informative since a number of user are required to share thisaccount).
My only concern is that the current implementation of Role, while SQL
compliant is almost completely useless. Any user can login with any
role -- so how can access to the SYSDBA functions be limited?... they
can't.
The change of SYSDBA from a user to a "role" would be a good thing, only
if the implementation uses a security "group" metaphor to which a user
must be added as a member and not a property which is set as a value at
login.
Sean