Stuart McLachlan
stuart at lexacorp.com.pg
Thu Jun 3 22:56:37 CDT 2004
On 4 Jun 2004 at 14:49, David Emerson wrote: > SQL2000 AXP ade > > I am using Windows NT Integrated security. The users will be members of NT > Groups (specifically set up for the SQL databases), and the NT Groups will > be members of SQL Roles. SQL permissions are then applied to the roles. > > However, within the ade I would like to know what role the current user > belongs to so I can make the form changes. Is there a system command that > will give me this info? > Take a look at sp_helpuser and current_user -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.