Re: ODBC and Security

ash@softec.sk (Zdeno Miklas) wrote: >You can do it using roles. Anybody demands password on role, >but it isn't necessary. A name of any role don't need to be >public and additionally you can implement encrypting >mechanism to make finding a name more difficult. I think 'select * from sysusers' will get you the name of the role. So when you have readonly access (for reports) you find the name. ============================================================================ Harald Ums | email: Harald.Ums@t-online.de Dietramszeller Stra'e 8a | Ums.Harald@fhm.de D-81371 M'nchen | ============================================================================